Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Dynamic OBIEE Hierarchy Tree

Received Response
55
Views
5
Comments
OhBeeEye
OhBeeEye Rank 1 - Community Starter
edited Aug 13, 2024 5:58PM in Oracle Analytics Cloud and Server

I am trying to create an Org Hierarchy Tree(Presentation Table) that can dynamically change the starting point based on a prompt or level of security.

For example, if you pick a Org-Level-2 organization as a prompt, the tree should start from the Org Level 2 even though the Logical Hierarchy is built to cover the level 1 to level 5.

Since you can't have two Hierarchy trees in one report, I can't apply the dynamic actions from prompt or security to pick a different hierarchy tree(I built different trees based on scenarios) from RPD.

Can anyone build a dynamic hierarchy tree in the report and share the solution?

Thanks,

Answers

  • John_K
    John_K Rank 5 - Community Champion

    If you can get the name of the starting column into a variable then you can just use that variable as your column formula. The variable will expand out to the column name, which will in turn display the appropriate value.

    So create a dashboard prompt which lets you select the value and sets a presentation variable for each level. Then create a hidden dashboard prompt which calculates the name of the level name into another variable based on the variables set in the first prompt. So you would calculate say "Person Hierarchy"."Level 4 Name" into a presentation variable XXSTARTING_LEVEL. Then you would set the formula of your column in your analytic to the variable XXSTARTING_LEVEL.

  • OhBeeEye
    OhBeeEye Rank 1 - Community Starter

    Hi ORA-01033,

    I already have a column with the PV that dynamically change the starting level and it works fine but I want to find out how to use the hierarchy tree that expands vertically instead of expanding the column.

    Thanks,

  • John_K
    John_K Rank 5 - Community Champion

    Ah - I see. I think you'd be into the realm of dragging in a hierarchical presentation column for each level (you just drag each level from the business model mapping into the presentation table) and then select the appropriate one dynamically.

  • OhBeeEye
    OhBeeEye Rank 1 - Community Starter

    I also created multiple hierarchy trees based on the level and I tried to create a different view per tree but if you drag in more than one hierarchy into a report criteria, you get the following error.

    "A hierarchy from the same dimension already exists in this report.  You can only add one hierarchy per dimension to a report."

    Also you said that select the appropriate hierarchy dynamically...How can you reference one of trees from a dynamic action?

    Thanks,

  • OhBeeEye
    OhBeeEye Rank 1 - Community Starter

    I found a solution for this.

    I added a Selection Step

       1. Select a Default Value from the Hierarchy column to Start

       2. Check "Overwrite with Prompt"

    Hierarchy tree start with a level based on the Hierarchy prompt selection.