Selection Type "Hierarchy Level" ('H'). 

The following example is based on:

·        The simplified InfoCube (sales figures) containing characteristics COUNTRY and CUSTOMER as well as key figure SALES (see Selection Type "All Characteristic Values" (‘*’))

·        The following external hierarchy for the countries:

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

COUNTRY	SALES
America	40
Europe	55

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.