Show TOC

Function documentationTab Page: Aggregation Locate this document in the navigation structure

 

Features

Aggregation:

There are four aggregation options:

  • Minimum (MIN): The minimum value of all the values in this column is displayed in the results row.

  • Maximum (MAX): The maximum value of all the values in this column is displayed in the results row.

  • Summation (SUM): The sum of all the values in this column is displayed in the results row.

  • No aggregation (X, if more than one value) (NO2): A value is only shown in the result cell if all values entered into the result cell have the same value. In the case of standard aggregation NO2, the exception aggregation must also be NO2.

    Note Note

    Key figures with standard aggregation NO2 can only be used in DataStore Objects for direct updates in planning mode, and in MultiProviders that contain these DataStore objects.

    End of the note.
Exception Aggregation

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

Example Example

The key figure Number of Employees would, for example, be totaled 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.

See also: Examples in the Data Warehousing Workbench

End of the example.
Reference 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. Often this is a time characteristic. However, you can use any characteristic you wish.

Flow/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. For the non-cumulative key figure, values are only stored for selected times (markers). The values for the remaining times are calculated from the value in a marker and the intermediary non-cumulative changes.

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

End of the note.

See also:

Aggregation

Rules for Standard Aggregation and Exception Aggregation

Modeling Non-Cumulatives with Non-Cumulative Key Figures

Aggregation Behavior of Non-Cumulative Key Figures