Dynamic OBIEE Hierarchy Tree

OhBeeEye

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,

John_K

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

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

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

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

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.