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?