Browsing SQL OLAP Cube in OWC Pivot Table using specific levels in dimension
Is there a way to enable users to view data by a specific level in a dimension (and not the parent levels as well) when the dimension is either a column or row field?
Let me explain in more detail:
eg. Time dimension has a typical time hierarchy -
Year, Half Year, Quarter, Month.
This dimension was set up in Analysis Manager as a regular dimension and all levels are set to 'regular' type.
I have set up OWC on our web server for clients to view the cube over the intranet.
I want them to be able to view data by specific levels when they drag the dimension as a column field (or row) - and not have the pivot table bring in the other levels along with the dimension. So if User X wants to see data at the Month level then: