Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Evaluate_Aggr OBIEE Essbase datasource

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