Show TOC

Selection Type "Hierarchy Level" ('H').Locate this document in the navigation structure

The following example is based on:

Example: Aggregate Country 'H' Level 2

  • Characteristic COUNTRY is used for compression on level 2 of the country hierarchy (Europe, America)
  • The characteristic CUSTOMER is not contained in the aggregate

Hierarchy level 2







This aggregate can be used in queries

  • That require sales for a node of the hierarchy on level 2 or higher, including queries that have the country hierarchy as presentation hierarchy in the drilldown and are not expanded deeper than level 2
  • That determine the total sum of the sales if:

    The hierarchy does not have multiple leaves, in other words, each variant of a characteristic occurs only once in the hierarchy

    Node "non-assigned" is not suppressed

The aggregate cannot be used if the third level of the hierarchy (Austria, Germany, USA) is required in a query.