SAP Knowledge Base Article - Public

3448625 - Week is not available as the granularity under 'current time interval' for the dimension in the drop down when creating restricted measure in SAP Analytics Cloud (SAC)

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

  1. Login to SAC.
  2. Open the story.
  3. Select the table.
  4. Click on 'Add Measure'.
  5. Select 'Create Calculated Measure'.
  6. Select the calculation 'Restricted Measure'.
  7. 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