Changing the view of a dimension in the Dimension Browser

You can change how a dimension is displayed in the Dimension Browser by removing its hierarchical structure and/or by inverting it.

In Flat View users can rearrange the order of dimensions in the Dimension Browser. This affects how the dimension is displayed in Alea Ad-hoc reports.

SeeAlea Ad-hoc reports.

By default, hierarchies are displayed from top to bottom, with the top level consolidated element at the top and the base level elements at the bottom. Inverting the hierarchy reverses this.

You can specify flat view and inverted hierarchy when you create a dimension.

To select flat view or inverted hierarchy:

  1. Click Dimensions in Database group on the ribbon.
  2. Select a dimension and click Edit.
    Alternatively, right-click a dimension and select Properties .
  3. Select Flat View and/or Inverted Hierarchy and click OK.