Symptom
- Restricted Measure does not work.
- Restricted Measure created in SAP Analytics Cloud does not filter the data based on the selected hierarchical node value.
Environment
- SAP Analytics Clouds 2024.21.11
Reproducing the Issue
- In SAP Analytics Cloud, create a SAP BW Live Connection.
- Create a Model based on an SAP BW Query containing Dimensions with a hierarchy.
- Create a Story, and add a Table based on the Model created in step 2.
- On the Table, under Dimensions, create a Restricted Measure.
- Set the value of the Restricted Measure based on a Hierarchy node value.
- When viewing the Story, notice the Restricted Measure does not filter on the hierarchy node value selected.
Cause
- The SAP BW System was missing some of the required SAP Note, as listed in the SAP Analytics Cloud documentation in the section:
Backwards Compatibility Guidance for Using Optimized Story Experience with SAP BW
- It was also missing SAP Note 3559151
Resolution
- Load all the SAP Notes to the SAP BW System, that are listed in the SAP Analytics Cloud documentation in the section:
Backwards Compatibility Guidance for Using Optimized Story Experience with SAP BW
- Also, load to the SAP BW System the SAP Note 3559151
Keywords
SAC, Restricted Measure , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0