Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

Generating Level 0 members dynamically in an OBIEE 12c report

Received Response
21
Views
4
Comments
3066492
3066492 Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications Forum

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) ).

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics & AI Lead

    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
    3066492 Rank 3 - Community Apprentice

    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
    3066492 Rank 3 - Community Apprentice

    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
    ArijitC Rank 6 - Analytics & AI Lead

    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