Selection Type "All Characteristic Values" ('*') 

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 '*'

·        Characteristic COUNTRY is used for grouping

·        Compressed using characteristic CUSTOMER

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 based on a navigation attribute for characteristic COUNTRY or a hierarchy of the countries

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

·        Grouped using navigation attribute INDUSTRY

·        Compressed using characteristic CUSTOMER

Industry aggregate

INDUSTRY	SALES
Technology	60
Consumer products	25
Chemical industry	10

The aggregate can be used

·        In a query that is used to determine the sales for each industry or the total sales

·        For evaluations based on node values, if a hierarchy exists for the industries

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

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