Aggregation Level "All Characteristic Values" ('*') (SAP Library

Aggregation Level "All Characteristic Values" ('*')

The following examples assume a simplified InfoCube (sales figures), containing the characteristics 'COUNTRY' and 'CUSTOMER' and the key figure 'SALES'.

Example - InfoCube

COUNTRY	CUSTOMER	SALES
USA	Buggy Soft	10
Germany	Ocean Networks	15
USA	Funny Duds	5
Austria	Ocean Networks	10
Austria	Thor Industries	10
Germany	Funny Duds	20
USA	Buggy Soft	25

Example 1: Aggregate Country '**'

Characteristic 'COUNTRY' is used for grouping.

Characteristic 'CUSTOMER' is used for compressing.

COUNTRY	SALES
USA	40
Germany	35
Austria	20

The data for key figure 'SALES' is listed for the sum of the sales for each country and not for individual customers.

The aggregate can be used

In a query that determines the sales for each country or the total sales
For evaluations using a navigation attribute for characteristic 'COUNTRY' or using a hierarchy on the countries

The aggregate cannot be used if you want to expand or select in a query using characteristic 'CUSTOMER' because it does not contain any information about the customers.

Example 2: Aggregate Industry '**'

In the second example for aggregation level 'All characteristic values', the industry is needed as a navigation attribute. The following master data table is used here:

Master Data Table - Customer

CUSTOMER	Industry
Buggy Soft	Technology
Ocean Networks	Technology
Funny Duds	Consumption
Thor Industries	Chemicals

Navigation attribute 'INDUSTRY' is used for grouping.

Characteristic 'CUSTOMER' is used for compressing.

Industry aggregate

INDUSTRY	SALES
Technology	60
Consumption	25
Chemicals	10

The aggregate can be used

In a query that determines the sales for each industry or the total sales
For evaluations by node values if there is a hierarchy for the industry

Detailed information cannot be obtained about characteristic 'CUSTOMER' with the exception of the industry to which the customer is assigned.

Example 3: Aggregate Sales Person '**'

In the third example for aggregation level 'All characteristic values', the time-dependent navigation attribute Sales person is needed. The following table is used here:

Sales Person Table

COUNTRY	FROM	TO	SALES PERSON
USA	01.01.2000	31.12.2000	Smith
USA	01.01.2000	31.12.2001	Miller
Germany	01.01.2000	31.03.2001	Meyer
Germany	01.04.2000	31.12.2001	Huber
Austria	01.01.2000	31.12.2001	Huber

Navigation attribute 'SALES PERSON' is used for grouping.

Characteristic 'COUNTRY' is used for compressing.

Key Date: Sept. 01, 2001

SALES PERSON	SALES
Miller	40
Huber	55

The aggregate can be used in a query that has the same key date as the aggregate.