Aggregation Level "Hierarchy Level" ('H'). (SAP Library

Aggregation Level "Hierarchy Level" ('H').

Assume

the simplified InfoCube (sales figures) containing characteristics ‘COUNTRY’ and ‘CUSTOMER’ as well as key figure ‘SALES' (see Aggregation Level "All Characteristic Values" (‘*’)),

The following external hierarchy for the countries:

Example: Aggregate Country 'H' Level 2

Characteristic 'COUNTRY' is used to compress 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 need sales for a node of the hierarchy on level 2 or higher, including such queries that have the country hierarchy as presentation hierarchy in the drill-down and are not expanded deeper than level 2.
That determine the total sum of the sales if

The hierarchy does not have any multiple leaves, i.e. each variant of a characteristic only occurs once in the hierarchy,
Node "Remaining" is not suppressed

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