Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

How to calculate #missing in OBIEE.

Received Response
1
Views
1
Comments
2676093
2676093 Rank 1 - Community Starter
edited Aug 13, 2024 5:57PM in Oracle Analytics Forum

How to calculate #missing in OBIEE. I have 3 unions in OBIEE but in the report i get no data due to #Missing, Data source is Essbase. Thank you

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    If a data value does not exist for a unique combination of members, Essbase gives the combination a value of #MISSING.

    How can you calculate where nothing exists?  examples:

    X + #MISSING = X

    #MISSING - X = -X

    X * #MISSING = #MISSING

    X / #MISSING = #MISSING

    Not sure what your end game is on this one...