This content has been marked as final. Show 3 replies
I've created 4 hypercubes for my drilldown (in a mashup), one for Region, one for Sub-Region, Cluster and for Country too.
When I select from the first level (select a region, let's say Europe), the sorting functionality works fine for the drilldown and for the other KPI-s and charts but in the drilldown other data is displayed as well. I mean there's data for example for Latin American countries even if I've selected Europe and those extra columns shouldn't be there. I've attached a screenshot to this discussion to make it more clear.
The desired behavior in the example would be that only those sub-regions displayed which is under the Europe region. (the first 7 sub-region should appear in the drilldown).