Oracle Analytics

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

Parent member in dashboard prompt should select child hierarchy as column

Received Response
1
Views
1
Comments
Sam999
Sam999 Rank 3 - Community Apprentice
edited Aug 13, 2024 7:09PM in Oracle Analytics

We have a OBIEE-Essbase(ASO) reporting application and have a requirement where a parent member selection should show its immediate child level hierarchy.

Any suggestions on how to go about it.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    CASE statement in the column formula which then uses a certain presentation layer object depending on a presentation variable populated by the dashboard prompt.