SAP Knowledge Base Article - Public

3579255 - Restricted Measure is not considering leap day when using year granularity for table based on SAP BW Live Connection in SAC

Symptom

  • Restricted measure with year granularity range not displaying any data in table for leap day in Optimized Design Experience.
  • Similar restricted measure with month granularity range and EXACT same date range succeeds in showing data on table.

Environment

SAP Analytics Cloud 2025.1.6 

Reproducing the Issue

  1. Login to SAP Analytics Cloud
  2. Create an SAP BW Live Connection to an SAP BW System
  3. Create a Model based on an SAP BW Live connection, and select an SAP BW Query
  4. Create an Optimized Design Experience Story
  5. Add a Table widget based on a Model based on an SAP BW Live Connection
  6. Create a restricted measure and select values by “Range”
  7. Set range granularity to “Month”
  8. Observe in table that the data for a leap day dimension member is empty

Cause

Issue is under investigation by development

Resolution

Issue is under investigation by development

Keywords

SAC, leap year, bw , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , Problem

Product

SAP Analytics Cloud 1.0