Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Evaluate_Aggr OBIEE Essbase datasource

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?
Answers
-
Just used IfNull in OBIEE which resolved my issue.
0