SAP Knowledge Base Article - Public

3105783 - Unable to change date format in SAP Analytics Cloud (SAC)

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • Cannot modify the format of a Date Dimension in a Story

Environment

SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1.  Create a Story
  2.  Insert a Table with Date Dimensions, the Date Dimensions are shown with YYYY-MM-DD format

Cause

Date Format must be done at Model level:

Resolution

  1.  When creating the Model, select Date Dimension
  2.  Set Type to Date Dimension (if not automatically detected)
  3.  Set  Date Format to the desired format i.e.  DD/MM/YYYY

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 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0