In a query, it is possible to choose how key figure values are aggregated. You can use different characteristics and characteristic values in your aggregation definition. To calculate the value of each key figure in the query, the data from the InfoProvider must be aggregated to the detail level of the query. Formulas may also need to be calculated.
Standard Aggregation
When performing standard aggregation, key figures are aggregated according to the Summation (SUM), Minimum (MIN), or Maximum (MAX) rules.
Standard aggregation is independent from specific characteristics; it is applied to all characteristics that are not in the drilldown, irrespective of their sequence.
Exception Aggregation
Can only be implemented in the properties of a formula or a calculated key figure, where basic and restricted key figures can be included.
Needs one or more reference characteristics to define the granularity with which the aggregation rule is applied.
Exception Aggregation Rules
Exception Aggregation Rules
The following table describes some examples of rules for exception aggregation.
Abbreviation | Aggregation Rule | Description |
---|---|---|
AVG | Average of all values | The average of all values is displayed. |
CNT | Count all values | The number of available values is displayed in the result line. |
MAX | Maximum | The highest value of all displayed values in this column is displayed in the result line. |
MIN | Minimum | The lowest value of all displayed values in this column is displayed in the result line. |
VAR | Variance | If you drill down to the reference characteristic, the variance of the displayed values is displayed in the result line. |
Configuring Exception Aggregation
There are two approaches to defining exception aggregation:
In the modeling settings of a key figure InfoObject.
You can configure exception aggregation during modeling of key figures if the exception aggregation is going to be applied to all queries.
For Non-Cumulative key figures, you must configure exception aggregation (for example, Last Value) to avoid incorrect aggregation over time characteristics.
In the properties of formulas or calculated key figures in SAP BW Query Designer in SAP HANA Studio.
Add or change exception aggregation settings for each query by creating a formula object, adding operands, and defining the type of exception aggregation for the reference characteristics.
