Show TOC

To display single dimensions as hierarchyLocate this document in the navigation structure

Context

If you use multiple dimensions in your analysis, you can display them as flat presentation or as hierarchy in the crosstab.

As of step three, the steps in the following procedure are optional. You can use the options you need the define your view on the data.

Procedure

  1. Move at least two dimensions to the Rows section in the design panel.
    Note Dimensions can also be moved to the Columns section. This procedure describes dimension in the Rows section. Dimensions in columns behave accordingly.
    The dimensions are displayed side by side in the crosstab.
  2. Change to hierarchical display.
    Select a crosstab cell and choose Start of the navigation path Hierarchy Next navigation step Compact Display in Rows End of the navigation path.
    The dimensions in the crosstab are displayed as hierarchy. The first dimension in the Rows section is the first level in the hierarchy. Nodes with a + contain subnodes.
  3. Expand/Collapse all nodes.
    Select the cell with the dimension name in the crosstab and choose Start of the navigation path Hierarchy Next navigation step Expand to Dimension  Next navigation step <Dimension Name> End of the navigation path. The number of available dimensions depends from the number of dimensions in the Rows section.
    The hierarchy in the crosstab is expanded according to your selection. To collapse the hierarchy, choose the first dimension.
  4. Expand/Collapse a single node.
    Select a node cell in the crosstab that you want to expand and choose Start of the navigation path Hierarchy Next navigation step Expand Dimension <Dimension Name> End of the navigation path.
    The selected node is expanded to the next dimension below. To collapse the subnodes of a selected node, choose Start of the navigation path Hierarchy Next navigation step Collapse End of the navigation path. You can also select the +/- symbols to expand and collapse a single node.
  5. Define the sequence of the dimensions in the hierarchy.
    The sequence of the dimension in the Rows section determines their level in the hierarchy. The first dimension in the design panel is the first level in the hierarchy. By using drag and drop, you can move the dimensions up and down. The levels in the hierarchy are changed immediately.
    The hierarchy is displayed from child level to parent level.
  6. Display the dimensions again as flat presentation.
    Select a crosstab cell and choose Start of the navigation path Hierarchy Next navigation step Compact Display in Rows End of the navigation path.
    The dimensions are again displayed side by side in the crosstab.

Results

The dimensions are displayed according to your definition.