Symptom
- Does the SAP BW Compare to Measure Threshold supported?
- Does SAP Analytics Cloud support the SAP BW functionality: Compare to Measure Threshold?
Environment
- SAP Analytics Cloud 2024.11
- SAP BW 7.x
Cause
- The IF formula, used by the InA provider to process Compare to Measure (C2M) thresholds in InA queries, is only supported in SAP BW version 7.5 or higher. As SAP Analytics Cloud does not perform an SAP BW version check, C2M should not be used with lower SAP BW versions than 7.5 as it is no longer supported.
- For more information, please refer to:
- SAP Analytics Cloud Help : Guidance for Using Optimized Story Experience with SAP BW
- SAP Knowledge Base Article : 2715030
Resolution
- Percentage Measure as Base Measure or Reference Measure
SAP BW Models may have percent measures derived and built in, with percentage functions marked as "Percentage Functions" in SAP BW Modeling Tools. For percent measures, the CellValueType is set to 1 in the InA protocol, which allows SAP Analytics Cloud to render values as percentages. This also applies to some calculations or formulas, for example, ‘percentMeasure/aNumberMeasure’. However, when a percent measure is used either as a base measure or a reference measure in an SAP BW C2M threshold, the CellValueType of the corresponding IF formula result is 0, indicating a double value. The result is a percentage value. SAP Analytics Cloud multiplies the result by 100 to return a percentage, and this may cause the C2M threshold results to fall into the wrong range.
- Measures with the following local calculations are not supported:
- Calculate Result As
- Calculate Single Value As
- Cumulated
- For more information, please refer to the SAP Knowledge Base Article: 3352673
Keywords
SAC, SAP BW Query, BEx Query , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-DAN , SAC Data Analyzer , LOD-ANA-FLY , Firefly used for HANA , How To
Product
SAP Analytics Cloud 1.0