The following example is based on a simplified InfoCube (sales figures) containing characteristics COUNTRY and CUSTOMER as well as key figure SALES (seeSelection Type "All Characteristic Values" ('*')),
Example: Aggregate Country 'F' = DE; Customer '*'
The aggregate only contains data for characteristic value 'Germany'.
Fixed Value: Germany
COUNTRY |
CUSTOMER |
SALES |
Germany |
Ocean Networks |
15 |
Germany |
Funny Duds |
20 |
The aggregate can only be used in queries that have the same filter value.
The aggregate cannot be used if other countries are required in a query.
We recommend that you use filter values for aggregates if only one variant is needed for reporting, for example: