Evaluate_Aggr OBIEE Essbase datasource

user10067081

Hi Experts,

I am relatively new to OBIEE. I am trying to retrieve data in OBIEE analysis measure using the formula

Evaluate_AGGR('/*%1*/([Actual],[61000_00],[FY14])' as DOUBLE ,"Measures"."Gen1,Measures" ) + Evaluate_AGGR('/*%1*/([Actual],[62000_00],[FY14])' as DOUBLE ,"Measures"."Gen1,Measures" )

It gives correct results when both the combinations 61000_00 & 62000_00 have data but gives null when one of it is #Missing in Essbase. I am having Cost Center dimension on rows and Measures in column.

Any ideas?

user10067081

Just used IfNull in OBIEE which resolved my issue.