SAP Knowledge Base Article - Public

2978363 - Wrong date format value in table in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

Symptom

When creating a table in an SAC story the date format is wrong whereas in a numeric point it is expressed correctly.
Whenever the value is less than 24 hours the result is displayed correctly but any values above 24 hours are displayed in the wrong format.

This behavior works by default in Analysis for Office; however, SAC is unable to parse this format correctly.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.21.0
  • BW Live

Reproducing the Issue

  1. Build a model based on BW live with a date dimension.
  2. Build a story based on this model and create a table and a numberic point
  3. Observe that the date value in the numeric point is correct but in the table is incorrect.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, date, format , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0