SAP Knowledge Base Article - Public

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

Symptom

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

Environment

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.

Cause

This is behavior by design.

Resolution

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

Keywords

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

Product

SAP Analytics Cloud 1.0