Hierarchical Prompt for dep tree with OTBI

Summary:

Hierarchical Prompt for dep tree with OTBI

Content (please ensure you mask any confidential information):

Hello experts, we have configured in OTBI a report with some employee's assignment info and his department hierarchy. We have then created a prompt with 4 dep hierarchy fields (dep level 1, dep level 2, dep level 3, dep level 4) and we would like that once the user selects in the prompt the dep level 1 filter, the list of values of the dep level2 filter shows only the departments which are located below the dep level 1, based on how the dep tree has been defined and structured, instead of showing all departments of the level 2. Does