Tab Page: Aggregation 

Features

Aggregation:

There are three aggregation options:

...

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

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

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

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.

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

The following exception aggregations are possible:

●      Average (value not equal to zero) (AV0): After drilling down according to the reference characteristic, the average of the column value not equal to zero is displayed in the results row.

●      Average (weighted with no. of days) (AV1): After drilling down according to the reference characteristic, the average of the column value weighted with the number of days is displayed in the results row.

●      Average (weighted with the number of workdays; factory calendar) (AV2): After drilling down according to the reference characteristic, the average of the column value weighted with the number of workdays is displayed in the results row.

●      Average (all values) (AVG): The average of all values is displayed.

●      Counter (value not equal to zero) (CN0): The number of values <> zero is displayed in the results row.

●      Counter (all values) (CNT): The number of existing values is displayed in the results row.

●      First value (FIR): The first value in relation to the reference characteristic is displayed in the results row.

●      Last value (LAS): The last value in relation to the reference characteristic is displayed in the results row.

●      Maximum (MAX): see above 

●      Minimum (MIN): see above 

●      No aggregation (exception if more than one record arises) (NO1)

●      No aggregation (exception if more than one value arises) (NO2)

●      No aggregation (exception if more than one value <> 0) (NOP)

●      No aggregation along the hierarchy (NHA)

●      No aggregation of postable nodes along the hierarchy (NGA)

●      Standard deviation (STD): After drilling down according to the reference characteristic, the standard deviation of the displayed values is displayed in the results row.

●      Summation (SUM): see above 

●      Variance (VAR): After drilling down according to the reference characteristic, the variance of the displayed values is displayed in the results row.

See also Aggregation Behavior of Non-Cumulative Key Figures.

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

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.

More Information:

Aggregation

Modeling Non-Cumulatives with Non-Cumulative Key Figures