|
Hi All, I am very new to SSAS and I have a requirement where I have to filter the cube data to show top 10 items at each level of hierachy. For example the hierarchy looks something like below... Country-->State-->City-->so on ... and I have to get top 10 sales amount for countries,state, city ... the output should be somethong like... Top 10 countries net sales amount, if i click on a country it should show top 10 states net sales amount and if i click on a state it should show top 10 cities net sales amount and so on.. I tried something like below but not getting the correct output. Please someone help me with this. Thanks,
(comments are locked)
|

