1 Reply Latest reply on Aug 2, 2017 12:34 PM by Thomas Dodds

    How to calculate #missing in OBIEE.

    2676093

      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

        • 1. Re: How to calculate #missing in OBIEE.
          Thomas Dodds

          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...