BO-WEBI Hierarchy related:
I have a table with fields STATE and CITY and POPULATION.
Assume in the Universe class I have STATE and then the CITY objects in sequence so as to be helpful for drill downing..
When I create a query I dragged STATE object in my query and If I do so I need to see a + sign next to the State so that when I press that + sign it need to expand and show all the cities under that state in the same column with POPULATION for each city and when I collapse it I should just see state and its total population. How do I accomplish something like this..?