Tree: Overview

A tree is a more compact representation of a multi-dimensional cube.  The cells are calculated in the same way as a cube but the dimensions categories are represented as nodes in the tree.  

Tree views may be "collapsible" or "flattened" - selected using the icons or on the toolbar.

Example Collapsible Tree on Occupation and Source

Initially the breakdown of cells by the first dimension is displayed.  Each cell can be opened by clicking to reveal the breakdown by the second dimension.  In this way you can delve into the more interesting areas of the results without being overwhelmed by the number of cells.

A tree may also be transformed to a "flattened" view.  This results in all cells being displayed and referenced by their dimension coordinates.  This is particularly useful if combined with sorting by the count to reveal the most highly populated cells.

 

You can add statistics into a tree in the same way as you do a cube. For information on working with statistics, see:

• Cube: How do I include Statistics on a Cube?

• Cube: How do I use and interpret the different statistics?

• Cube: How do I re-order, edit, hide or delete statistics in a Cube?

• Cubes: How do I pivot statistics on a Cube?

• Cube: How do I apply Calculated Measures to a Cube?