Scenarios for the Use of an Exception
Aggregation 
Non-cumulative key figures:
An example for the use of standard aggregation and exception aggregation for a key figure is a key figure for the non-cumulative value.
With non-cumulative values such as warehouse stock, you want to total up the warehouse stock for various articles and warehouses (standard aggregation), but for the month you want to determine the ending inventory (LAST aggregation) (exception aggregation in regard to the time characteristic Calendar Month).
See also: Aggregational Behavior of Non-cumulative Values
Counter:
Another example for the use of standard aggregation and exception aggregation for a key figure is a key figure is the key figure as counter.
For example, you have an InfoCube Employee Appraisal:
Emp. No. |
Type of appraisal |
Year |
No. of employee appraisals |
4711 |
Potential assessment |
2002 |
1 |
4711 |
Target achievement |
2002 |
0 |
4711 |
Performance appraisal |
2002 |
1 |
4712 |
Potential assessment |
2002 |
1 |
4712 |
Target achievement |
2002 |
0 |
A query would supply the following result:
Employee 4711 is counted twice here because the various types of appraisal are counted together, which would render the result incorrect. To prevent this, the key figure Number of Emp. Appraisals receives an exception aggregation (such as Average (Values Not Equal to Zero) via the characteristic Type of Appraisal. Then the Number of Emp. Appraisals is not totaled.
The query then appears as follows:
