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 the dimension the 'week' as the granularity is not coming under the current time interval.

  • The hierarchy for the dimension is YWD (year, week and day) from the Datasphere side. Same behavior in table and chart.

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

The issue is currently under investigation by the development team.

Resolution

The issue is currently under investigation by the development team.

Keywords

restricted measure, dimension, week, granularity. , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0