obiee 12c calculated measure from two other measures - incorrect values

Raj453

Thanks Rob, your suggestion to use Server Complex Aggregate worked, but i have to create duplicates of measures A and B and then use them in C.

SonPat99

Sometimes you have to go an extra mile...

I think the calculation/aggregations for Columns A and B were not happening in the way you wanted...

Applying "Server Complex Aggregate" rule forced the calculation to be applied in a specific way.

Best explanation is in the below blog:

https://gerardnico.com/dat/obiee/obis/server_complex_aggregate

This aggregate rule will also apply the (fraction|average) aggregation ie:

• a sum for the numerator
• a sum for the denominator
• and getting the end result dividing one into the other.

I think you do not require any new columns. Just try using this functionality in the Column C.

Raj453

Thanks SonPat,  i am still confused with OBIEE behind the scenes calculation behaviour.

[Deleted User]

^-- an example for pre-agg vs post-agg

Raj453

Thanks Chris.