Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
736
Views
25
Comments
13»

Answers

  • Raj453
    Raj453 Rank 3 - Community Apprentice

    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
    SonPat99 Rank 6 - Analytics Lead

    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
    Raj453 Rank 3 - Community Apprentice

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    pastedImage_0.png

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

  • Raj453
    Raj453 Rank 3 - Community Apprentice

    Thanks Chris.