The following examples are based on 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 '*'
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
You cannot use the aggregate if characteristic CUSTOMER is used for drilldown or is selected in a query because the aggregate does not contain any information on the customer.
Example 2: Aggregate Industry '*'
In the second example for the selection type All Characteristic Values, INDUSTRY is required as the navigation attribute. We use the following master data table for this purpose:
Master data table: customer
CUSTOMER |
INDUSTRY |
Buggy Soft |
Technology |
Ocean Networks |
Technology |
Funny Duds |
Consumer products |
Thor Industries |
Chemical industry |
Industry aggregate
INDUSTRY |
SALES |
Technology |
60 |
Consumer products |
25 |
Chemical industry |
10 |
The aggregate can be used
With the exception of the industry which is assigned to each respective customer, you cannot retrieve detailed information for characteristic CUSTOMER.
Example 3: Aggregate Sales Person '*'
In the third example for the selection type 'All Characteristic Values', the time-dependent navigation attribute SALESPERSON is required. We use the following table for this purpose:
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 |
SALES PERSON |
SALES |
Miller |
40 |
Huber |
55 |
The aggregate can be used in a query that has the same key date as the aggregate.