Exception Aggregation (Specifics for SAP BW)
In SAP BW, the behavior for exception aggregation differs from SAP HANA.
Aggregation types COUNTNULL and AVERAGENULL are not supported for SAP BW.
NULL values resulting from restricted measures are ignored in exception aggregation. The following example shows the exception aggregation restricted to group 1 and group 2 based on the product group:
Product Group | Sales | Sales (Restricted) | Count on Sales (Restricted) | Average on Sales (Restricted) | COUNT excl. 0, NULL on Sales (Restricted) | AVERAGE excl. 0, NULL on Sales (Restricted) |
---|---|---|---|---|---|---|
SAP BW | ||||||
Group 1 | 100 | 100 | 1 | 100 | 1 | 100 |
Group 2 | 200 | 200 | 1 | 200 | 1 | 200 |
Group 3 | 300 | |||||
Totals | 600 | 300 | 2 | 150 | 2 | 150 |
SAP HANA | ||||||
Group 1 | 100 | 100 | 1 | 100 | 1 | 100 |
Group 2 | 200 | 200 | 1 | 200 | 1 | 200 |
Group 3 | 300 | 1 | ||||
Totals | 600 | 300 | 3 | 100 | 2 | 150 |