Show TOC

Hierarchy AttributesLocate this document in the navigation structure

You can set hierarchy attributes and thus influence how hierarchies are displayed and processed in reporting.

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 (see Modeling Nodes and Leaves). If you set this flag, these (additional) leaves are suppressed.
Display Behavior for Leaves of Inner Nodes Can Be Changed
You can set whether the afore-mentioned display behavior can be changed at query runtime.
Suppression of the Node Unassigned Nodes
If there are characteristic values that do not appear in the hierarchy, an Unassigned Nodes node is added to the hierarchy by default. If you set this flag, no Unassigned Nodes is created for the hierarchy.
Example There are 1000 characteristic values for characteristic Material. A hierarchy with material groups from a total of 100 materials is defined for it. The remaining nodes (1000-100, i.e. 900 characteristic values) are positioned under the Unassigned Nodes node. If you select Suppress 'Unassigned' Node, these 900 characteristic values are filtered out.
If a characteristic has a large number of values, but only a fraction of them appear in the hierarchy, the Unassigned Nodes node will contain a lot of nodes, and the internal hierarchy presentation will be very large. This can result in longer runtimes and problems when saving.
Root/sum position
You can specify here whether the root and total position of the hierarchy is displayed at the bottom in the hierarchy, with the leaves at the top, or whether the root and total position appear at the top, with the leaves at the bottom.
Start drilldown level
Here you can determine how many hierarchy levels in the query are included in then drilldown the first time it is called. If no number is entered, three levels are displayed.