Selection Type "Fixed Value"
(‘F’)
The following example is based on a simplified InfoCube (sales figures) containing characteristics COUNTRY and CUSTOMER as well as key figure SALES (see Selection Type "All Characteristic Values" (‘*’)),
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:
· The plan/actual indicator
· The current fiscal year
· Specific versions