Dynamic OBIEE Hierarchy Tree

Question

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,

OhBeeEye · Answer

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.

OhBeeEye · Answer

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,

John_K · Answer

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.