Oracle Analytics and AI

3066492

We want to know if it is possible to pull the level 0 members in a report ?

We have found this blog: Oraculam: OBIEE: Generate Level 0 members dynamically for an Essbase upper level member .

We tried to use the Solution 1 but we aren't able to get the syntax to work.(EVALUATE('Descendants([@{PV_Entity}], Levels([Entity],0))/*%1*/' ,"Entity"."Gen1,Entity")

Once we have used this syntax in a column and click 'OK'. After navigating to the Results tab we see this error: : 96002. [nQSError: 96002] Essbase Error: Syntax error in input MDX query on line 3 at token '[' (HY000) ).

ArijitC

First good to see someone actually reading a blog that I thought no one reads.

You need to add a default member for this to work in analysis. Otherwise the analysis will work in dashboard when you submit with a presentation variable.  PV_Entity is the presentation variable here.

To work in analysis Do this..

(EVALUATE('Descendants([@{PV_Entity}{ADD a default member here}], Levels([Entity],0))/*%1*/' ,"Entity"."Gen1,Entity")

Thanks

Arijit