Generating Level 0 members dynamically in an OBIEE 12c report

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

3066492

I appreciate that, blogs provide valuable information. Thank you for your reply ArijitC! I will try to add your solution and see if this works.

3066492

I used you solution and now I am receiving an error saying:

[nQSError: 12010] Communication error connecting to remote end point: address

Any ideas?

ArijitC

I have seen this error ( not related to Evaluate) when presentation services are down.

I would check following things...

1. if everything is up and running.

2. If the user that you connecting with have access to essbase to run that query.

3. I'm sure you already have required setting for Evaluate. Just double check if anything is pending.

https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-C2C5B43E-4BB9-4ED7-94DE-D262698DCF98.htm#BIMIG-GUID-C2C5B43E-4BB…

4. check oracle KB. With the error you got, I found many documents that may apply to your case. specially check documents like Doc ID 2262746.1

Thanks

Arijit