Show TOC

Selection Type "Fixed Value" ('F')Locate this document in the navigation structure

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:

  • The plan/actual indicator
  • The current fiscal year
  • Specific versions