Calculation Editor (Specifics for SAP BW)
There are specific issues you need to be aware of when you use the calculation editor in SAP Analytics Cloud with SAP BW live data connections.
You can use the calculation editor to create custom calculations such as aggregations, calculated or restricted measures, and so on. However, before creating calculations for SAP BW live data connections, you may need to make modifications or apply some SAP notes. The following sections list the special requirements for different calculation types.
Specific Considerations for Calculated Measures in SAP BW
In case you create a calculated measure based on measures with their sign reversed, the following behavior applies:
-
If the calculated measure is based on one single measure, sign reverse is inherited.
-
If the calculated measure is based on two or more measures and one of them is not reversed, sign reverse will be ignored.
Specific Considerations for Restricted Measures in SAP BW
The creation of a restricted measure on top of another restricted measure with the same dimension is not supported.
To use calculated measures or other calculations in your restricted measures in SAP BW, you need to apply the fix described in the following SAP Note.
SAP Note 2984958 
desc: InA: Local selection (measure) not updated
if dependent object changed
Specific Considerations for Calculating the Difference in SAP BW
Before creating a calculation to calculate the different between time periods in SAP BW, you need to apply the fix described in the following SAP Note.
SAP Note 2982652 desc: Dynamic selection using current member
Specific Considerations for Exception Aggregation in SAP BW
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 |