Evaluate_Aggr OBIEE Essbase datasource — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Evaluate_Aggr OBIEE Essbase datasource

Received Response
1
Views
1
Comments
user10067081
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?

Answers