Skip to Content
0
Former Member
Nov 26, 2009 at 12:47 PM

[BO XI 3.1] Hierarchy with Cascading prompt

32 Views

Hi all (don't know if this is the right section, if no, please move the topic in the right section)

I have a hierarchy defined in my universe, let's say I have:

-Country

--Region

---City

-


Area

In the fact table I obviously have data linked only to the Area and neither to the Region nor to the Country nor to the City.

Now, I would like to define a prompt on the Area with a cascading LOV, allowing me to select the country as first, then the region, then the city and the area at last.This is quite simple as I can define the hierarchy in the universe designer, then I can define the cascading LOVs and when I set a prompt on the area, the prompt comes out with the hierarchy defined as a treeview. Easy.

But, what about If I would like to select only the region and grab all the areas for all the cities of that region? I have to navigate the whole tree to reach the leafes(the areas) and I am not allowed to select the middle levels of the tree as the intermediate cells are not selectable.

For example:

I would like to have all the information about California. In the prompt: I first select USA, then I select California. Now I have to keep on navigating the tree to reach all the leaves and select all the areas one by one. I am not allowed to select just California (as this is an intermediate tree level) and fire the query.

Is there any way/workaround to achieve this?