How to Show More Hierarchy Levels in Your Table
Expand your table's hierarchical data to specific levels for one or more dimensions.
Your data is loaded into a table with the hierarchies collapsed. You can select the expand arrow to show another level of data for the current member cell, or you can use the menu to expand all members at the same level.
There are times when the system is retrieving data that it can't determine the actual number of levels in a hierarchy. In those situations, the drill menu will show five levels, even if there are fewer than five levels in your hierarchy.
If you have more than five levels, you can use the drill menu to expand your hierarchy to Level 5 and then use the expand arrows in the table to expand the remaining levels.
To expand the hierarchy, right-click a dimension header, selectDrill, and then select the level that you want to expand to (drill to).
In the dialog that appears, select a Dimension and a Drill Level.