Context
By using a data source that contains a dimension
with hierarchies, you can define different views on the hierarchies of the
dimension. You can also display the members of the dimension in a flat
presentation.
As of step two, the steps in the following
procedure are optional. You can use the options you need to define your view on
the data.
- Move a dimension with hierarchies to
the Rows section in
the design panel.
Note Dimensions can also be moved to the
Columns
section. This procedure describes dimensions in the
Rows
section. Dimensions in columns behave accordingly.
The dimension is displayed in the crosstab according to the
definition in the BEx Query Designer. If the dimension is defined with an
active hierarchy and active attributes, the dimension is displayed in the
crosstab accordingly. Nodes with a
+ contain
subnodes. In the design panel, the active hierarchy and attributes are
displayed in bold letters in the
<data
source> section.
If no hierarchy
is active in the query definition, the data is displayed in a flat
presentation.
- Select a different hierarchy.
Select a different hierarchy
of the dimension in the
<data
source> section in the design panel and move it to the dimension
in the
Rows
section.
Only one hierarchy of a dimension can be active at the same time.
The data in the
crosstab changes according to your selection. The selected hierarchy is now
active and displayed in bold letters in the
<data
source> section.
- Activate attributes
Select an attribute of the
dimension in the
<data
source> section and move it to the dimension in the
Rows
section.
Multiple attributes can be active at the same time.
The data in the
crosstab changes according to your selection. The selected attribute is now
active and displayed in bold letters in the
<data
source> section.
- Expand/Collapse all nodes.
Select the cell with the
dimension name in the crosstab and choose
. The
number of available levels depends from the hierarchy.
The levels in
the crosstab are expanded according to your selection. To collapse the levels,
choose the first level.
- Expland/Collapse a single node.
Select a node cell in the
crosstab that you want to expand and choose
.
The selected
node is expanded to the next level. To collapse the subnodes of a selected
node, choose
. You can
also select the
+/- symbols
to expand and collapse a single node.
- Define the available levels of the
hierarchy.
Select a member cell of the
dimension in the crosstab and choose
.
Select the levels that should be available in the analysis and press
OK.
Only the
selected levels can be displayed in the crosstab. The total is not affected by
this selection because the leaf level is always available.
- Define the sequence of a hierarchy.
By default, a hierarchy is
displayed from parent level to child level. To change this presentation, select
the node of the first level and choose
.
The hierarchy is
displayed from child level to parent level.
- Display the dimension as flat
presentation.
Select the
Flat
Presentation node in the <data source> section of the design
panel and move it to the dimension in the
Rows
section.
The hierarchy is removed from the dimension and the members of the dimension are
displayed in a flat presentation.
- Switch between hierarchical and flat presentation.
You can activate and deactivate hierarchies in the design panel to switch
between hierarchical and flat presentation.
In the Rows section, choose Use Hierarchy
<HierarchyName> For Filter Only in the context menu for an
hierarchy to deactivate the hierarchy and switch to the flat
presentation.
The members of the dimension are displayed in a flat presentation in the
crosstab. The hierarchy information is removed in the design panel. If you open
the filter dialog for this dimension, the hierarchy is still active and can be
used for filtering.
To activate the hierarchy again and switch to the hierarchical presentation,
choose Use Hierarchy <HierarchyName> For Filter Only
in the context menu for the dimension.
Hierarchy 
Expand to Level 
. The
number of available levels depends from the hierarchy.
The levels in the crosstab are expanded according to your selection. To collapse the levels, choose the first level.