Hi,
I am trying to generate a page with multiple filters/slices in it. THey are all comming from CUBE and it is live connection to it. Dimension tables are connected via Fact tables. So now, I need to show slicers from different dimensions and it works well. It filters main table based on selected slicers/filter, but problem I face is that slicers/filters are not filtered itselfs. They show all unique values all time.
I would like, for example, when user selects Europe as Business area, it shows Countries in next filter which are only in Europe. Right now, it shows all. Yes, main table is filtered and shows only Europe numbers, and if I select Norway it shows only Norway numbers, but user can select Islamabad as well and because it is not in Europe table is empty.
How can I filter slicers/filters? Is there a visual which does this. Let me remind that data is not hierarchical all the time. Yes, Contintet=>COuntry=>City are hierarchical but Product is not. It shows all products. I would like to show (in filter/slicer Products) only those products that were sold in Norway.
