Function documentation Tab Page: Aggregation Locate the document in its SAP Library structure

Functions

Aggregation:

There are three aggregation options:

  1. Minimum
  2. Maximum
  3. Sum

Exception Aggregation

This field determines how the key figure is aggregated in the Business Explorer in relation to the exception characteristic. In general, this refers to time.

Example

The key figure ‘Number of Employees’ would, for example, be summed using the characteristic ‘Cost Center’, and not a time characteristic. Here you would determine a time characteristic as an exception characteristic with, for example, the aggregation ‘last value’.

Referenced characteristic for exception aggregation

In this field, select the characteristic in relation to which the key figure is to be aggregated with the exception aggregation. In general this is a time characteristic. However, you can use any characteristic you wish.

Cumulative and Non-cumulative Value

You can select the key figure as a cumulative value. Values for this key figure have to be posted in each time unit, for which values for this key figure are to be reported.

Non-Cumulative with Non-Cumulative Change

The key figure is a non-cumulative. You have to enter a key figure that represents the non-cumulative change of the non-cumulative value. There do not have to be values for this key figure in every time unit.

Non-Cumulative with inflow and outflow

The key figure is a non-cumulative. You have to specify two key figures that represent the inflow and outflow of a non-cumulative value.

Note

For non-cumulatives with non-cumulative change, or inflow and outflow, the two key figures themselves are not allowed to be non-cumulative values, but must represent cumulative values. They must be the same type (for example, amount, quantity) as the non-cumulative value.

See also:

Non-Cumulatives