SAP Knowledge Base Article - Public

3517584 - Date Difference calculation using timestamp dimension having any granularity is not working in SAP Analytics Cloud (SAC)

Symptom

Date Difference calculation using timestamp dimension having any granularity is not working in SAC story.

Environment

  • SAP Analytics Cloud (Enterprise) 
  • Embedded SAP Analytics Cloud
  • HANA MDS based models
    • Acquired models
    • SAP DataSphere (Live, Import)
    • SAP HANA (Live, Import)
      

Reproducing the Issue

  1. Create a story in SAP Analytics Cloud and add chart / table widget.
  2. Create Date Difference Calculation using timestamp dimension having any granularity.
  3. Failed to fetch data / Server error is displayed in widget.

Cause

The issue is caused by using older version of the HANA EPMMDS service.

Resolution

Minimum MDS version required to support this feature: HANA EPMMDS 2024.28

See Also

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

Keywords

SAC, story, calc, calculation, formula, date, time, stamp, diff, difference, hana, epm, mds, version,  , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions