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.

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…

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,