I have a cube Measure with a Customer Hierarchy.
The customer Hierarchy is with three levels. The first level has the ranking of the customers based on the measue. It is provided a rank for the customers from top to bottom based on the revenue generated by the customer on a whole.The second level is the
Customer identification and third level is Customer number.
I have provided the collection in the key columns and also provided relationships between the attributes in the Hierarchy.
After I process the cube when I browse to see top 20 customers based on a measure I see the top 20 customers on the x axis of the browser but I donot see any data in the measures area.
But I see the customers on the left hand side (X axis) are sorted perfectly with the measure showing empty for each cell.
Is there any option I am not aware of?
View Complete Post