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