Dimensional hierarchies are created or imported in the SAP source systems for Analysis for Office. A dimension can contain multiple hierarchies. In a hierarchy, dimension members are organized in a tree structure, similar to a corporate organizational chart or a family tree.
If a dimension has hierarchies associated with it, you will see Hierarchies when you expand the dimension in the Data Source area of the Design Panel's Analysis tab. Expand Hierarchies and drag the appropriate hierarchy name to wherever the dimension is in the crosstab (Rows/Columns.) The Flat Presentation removes any hierarchical display of the dimension members.
You can expand or collapse a single node of a hierarchy. Use the [+]/[-] symbols to expand and collapse a single node. Or you can select a node cell in the crosstab that you want to expand and from the Analysis ribbon choose Hierarchy → Expand to Level. The selected node is expanded to the level you select. To collapse the subnodes of a selected node, choose Hierarchy → Collapse.
The Show Levels . . . option allows you to bypass certain levels of the hierarchy that are displayed in the crosstab. Only the selected levels will appear. The total is not affected by this selection because the bypassed levels are still part of the total.
Typically, hierarchies expand from the top down or from left to right, and the totals for a level appear after the details that make up the total. You can change this behavior using the Expand Upwards (Rows)/Expand to Left (Columns) option. This action will position the totals before the details that make up the totals.
When you are displaying a hierarchy and sort measure values, the values are sorted within their levels by default.
To sort members independently of their group, choose Sort in the Analysis ribbon and choose Break Hierarchies. The figure Break Hierarchies activated shows the crosstab with all levels and details combined, sorted, literally, by the measure value.