SAP Knowledge Base Article - Public

3271354 - Calculated Measure Containing Time Navigation Does Not Display Results


In SAC, a Calculated Measure containing a date member does not display any results.


SAP Analytics Cloud (Enterprise) 2022.21.5 and higher

Reproducing the Issue

  1. Login to SAC and open a planning model.
  2. Switch to the Calculations Workspace.
  3. Select the Calculated Measure containing a date member and observe no results are seen in the Calculation Preview panel.



Stacked date member navigation is not supported in SAC.


Review the Calculated Measure to ensure that it is not configured to use nested date member navigation.

The following example contains stacked date member navigation and is not supported.

Calc1: LOOKUP([Measure] ,[d/Date]= Previous("Month", 1))

Calc2: LOOKUP([Calc1] ,[d/Date]= Previous("Month", 1))

Here, Calc2 references Calc1 that also contains a date member, therefore no results can be displayed for this Calculated Measure, as nested date navigation is unsupported.

See Also

Your feedback is important to help us improve our knowledge base.


SAC Planning, SAC Unexpected Results, SAC Calculations , KBA , LOD-ANA-ML-CAL , Calculation Management , Problem


SAP Analytics Cloud 1.0