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:
· 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.