Show TOC

Hierarchy AttributesLocate this document in the navigation structure

Use

In hierarchy maintenance, you can set hierarchy attributes and, as a result, influence the display and processing of hierarchies in reporting.

Note

When loading hierarchies, the hierarchy attributes are transferred from the old active version of the hierarchy. When loading via the PSA, they can be overridden by transfer rules.

Prerequisites

You are in the change mode for the hierarchy (seeEdit Hierarchy).

Functions

You can use the pushbutton Hierarchy Attributes in hierarchy maintenance to set the following Display Parameters for the Hierarchy Display in the Query.

Do Not Display Leaves for Inner Nodes in the Query

A postable node with lower-level nodes is displayed in the query by default with a leaf with the same text inserted under it (seeModeling Nodes and Leaves).

If you set this indicator, these (additional) leaves are suppressed.

Tip

If the aggregation of values of the lower-level nodes does not return a sensible value for the postable node, you can use this option for a "technical correction". The correction value which you post to the postable node in this case is "hidden".

Display Behavior for Leaves of Inner Nodes Can Be Changed

You can set whether it is to be possible to change the above display behavior at query runtime. The changeability of the display behavior has the following possible values:

' ' : The display behavior cannot be changed in the query. 'X': The display behavior can be changed in the query.

Suppressing the Not Assigned Node

If there are characteristic values that do not appear in the hierarchy, a Not Assigned node is added to the hierarchy by default. If you set this indicator, no Not Assigned node is created for the hierarchy (REST_H, seeHierarchy Nodes).

Note

If the hierarchy is selected as a presentation hierarchy, only those characteristic values are filtered that do not appear as leaves or postable nodes in the hierarchy. This is the case even if they are posted to data.

Tip

There are 1000 characteristic values for the characteristic "material". A hierarchy with material groups from a total of 100 materials is defined for it. The remaining (1000-100), that is 900 characteristic values, are positioned under node Not Assigned.If you set the indicator for Suppressing Not Assigned Nodes, these 900 characteristic values are filtered out.

Another typical example of where this is used is with a hierarchy that only contains the cost centers of one of many controlling areas.

Set this indicator when the hierarchy only contains one (relatively small) proportion of the characteristic values. This may well improve performance.

If a characteristic has a large number of values but only a fraction of them appear in the hierarchy, the Not Assigned node has a lot of nodes and the internal hierarchy presentation is very large.This can lead to longer runtimes and problems when saving.

Root/Sum Position

Here you can determine,

  • whether the root and therefore the sum item of the hierarchy is displayed bottom right in the query, with the leaves at the top
  • whether the root and therefore the sum item of the hierarchy is displayed top right in the query, with the leaves at the bottom
    Note

    This setting can be overridden in the Query Designer (seeCharacteristic Properties): Select the option Position of Lower-Level Nodes in the User Setting column in the dialog box Characteristic Properties, under the group header Hierarchy Properties, and choose up ordown as the value.

    You can also override this setting in the BEx Analyzer as well as in the Web using the appropriate entry in the context menu.

Start Drilldown Level

Here you can determine how many hierarchy levels in the query are included in drilldown when it is first performed. If no number is entered, then three levels are displayed.

Note

This setting can be overriden in the Query Designer (seeCharacteristic Properties): In the dialog box Characteristic Properties, under the group header Hierarchy Properties, select the option Expand to Level in the column User Setting, and enter the value >0.

You can also override this setting in the BEx Analyzer as well as in the Web using the appropriate entry in the context menu.