Examples of Exception Aggregation: Last
Value and Average
Non-Cumulative Key Figures:
An example of the use of standard aggregation and exception aggregation for a key figure is a key figure for the non-cumulative value (non-cumulative key figure).
For non-cumulative key figures such as warehouse stock, you want to summate the warehouse stock relating to various articles and warehouse (standard aggregation), but determining the final count relating to month (LAST aggregation) (exception aggregation relating to the time characteristic Calendar Month).
See also: Aggregation Behavior of Non-Cumulative Key Figures.
Numerator:
A further example of the use of standard aggregation and exception aggregation for a key figure is the key figure as a numerator.
You have, for example, an InfoCube called Performance Appraisal:
Pers. No. |
Type of Appraisal |
Year |
No. of Performance Appraisals |
4711 |
Potential assessment |
2002 |
1 |
4711 |
Goal achievement |
2002 |
0 |
4711 |
Performance appraisal |
2002 |
1 |
4712 |
Potential assessment |
2002 |
1 |
4712 |
Goal achievement |
2002 |
0 |
A query would deliver the following result:
Employee 4711 would be counted twice because the different appraisal types are added together, which would make the result incorrect. To avoid this, the key figure No. of Performance Appraisals has an exception aggregation (for example, Average (Values Unequal to Zero)) for the characteristic Appraisal Type. Then the No. of Performance Appraisals is not totaled.
The query then appears as follows:
