Tab Page: Aggregation
Use
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.
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.
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.
See also:
Rules for Standard Aggregation and Exception Aggregation