Symptom
While creating the calculation 'Restricted Measure' for a dimension the 'week' as the granularity is not coming under the Navigation.
Environment
SAP Analytics Version:
2024.2.15 (Client)
2024.2.8 (Server)
SAP Datasphere version: 2024.6.65
Reproducing the Issue
- Login to SAC.
- Open the story.
- Select the table.
- Click on 'Add Measure'.
- Select 'Create Calculated Measure'.
- Select the calculation 'Restricted Measure'.
- Select the dimension.
Notice that the 'week' granularity was coming for the navigation and not for the selection panel.
Cause
Restricted measure use the same hierarchy which has been defined for the dimension.
Resolution
- Whatever hierarchy has been selected for the dimension member, the 'Previous' under navigation will show that hierarchy only.
- If flat presentation has been selected for the hierarchy then you will be able to see the previous set hierarchy or the one which has been set as default.
Keywords
restricted measure, dimension, week, granularity. , KBA , LOD-ANA-DES , Story Design & Visualizations , How To
Product
SAP Analytics Cloud 1.0