SAP Knowledge Base Article - Public

3430466 - Unable to calculate the date difference in calculated measure in SAP Analytics Cloud


Unable to find the date difference option for a calculated measure in SAP Analytics Cloud.


SAP Analytics Cloud 2023.21.16

Connection - Live

Data source - SAP BW, SAP S/4HANA and SAP BPC Embedded Model 

Reproducing the Issue

  1. Login to SAC.
  2. Open the story.
  3. Select the chart for which you want to calculate the date difference.
  4. In Builder panel, choose Add Measure  > Calculations  > Create Calculation.
  5. The Calculation Editor dialog appears.

Notice that the date difference is not present in the drop down list.


This is behavior by design.


Currently, the date-based calculations are not possible to calculate in live connection with SAP BW, SAP S/4HANA and SAP BPC Embedded Model. Kindly submit an enhancement as per - 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?

See Also


SAP Analytics Cloud, live connection, calculated measure, date difference, restriction, model , KBA , LOD-ANA-DES , Story Design & Visualizations , Product Enhancement


SAP Analytics Cloud 1.0