Percentage Calculation

Smart measures/database delegated measure were introduced with XI R3+
In your case (prior to XI R3), you must calculate the percentage measure in the Webi document as a local variable, otherwise your percentage measure will not roll-up properly within the report!

Again, did you check your two “base” measures?
You MUST use SUM in the SELECT box, such as

SUM (myfactTable.Measure1)

That is in addition to SUM under properties!

See my other entry here explaining SQL aggregation and projection of measures.


Andreas :de: (BOB member since 2002-06-20)