I have written the same way as below to derive the descendants at level 0. EVALUATE('Descendants([@{PV_Entity}], Levels([Entity],0))/*%1*/' ,"Entity"."Gen1,Entity"). My current questions is with sort order of members displayed in OBIEE report. How can i prevent OBIEE sorting the members and keep them in same order they…

Thanks ArjitC. It worked as expected for us, to start with. Only challenge we have is, we have a limitation of 1 million of fetching rows on OBIEE side, so even if i have more than one essbase dimension set at top level (then OBIEE has to fetch all level 0 of these dimension), the combinations going more than a million and…

Thanks, Let me try these which option better works for me. I will have a good learning curve here. Ideally what i want to achieve is let users choose base members for each functional area (dimension), then report has to extract data at level 0 across all those dimensions from Essbase

That would be great if i can get the entire hierarchy in prompts. When i tried that, I see all the members of dimension are flatten and was not showing the typical Essbase like hierarchy. However even If i can get hierarchy in prompts, Can i make selection of a member and its children with a single click of check box, or…

hi Gianni, Yes i was exploring that today. It pulls the level 0 members for the base member i select from prompt, for which i already have done "New Hierarchy Selection Step", My challenge is that how can i dynamically pass the selected member from prompts to selection step? When working on selection steps I don't see…

Thank you. Let me explore them. Appreciate your help.

Thanks, I am newbie to OBIEE, i see this blogs says that pass the base member to a relational data source to pull its children/descendants. Do i need to build any relational db model with essbase metadata in OBIEE for that? In OBIEE, one can actually connect to Essbase to get the metadata information and then pass it to…