SAP Knowledge Base Article - Public

3105697 - Date dimension will changed to General after exporting SAC stories to XLSX


When exporting date in SAC to XLSX, the date type dimension will changed to General in Format cells.


  • SAP Analytics Cloud (Enterprise) 2021.20.1

Reproducing the Issue

  1. Create a story include date dimension. eg: 2021-05-06, 2021/05/06.
  2. Click Export.
  3. In File Type select XLSX.
  4. Save the XLSX file.
  5. Open the XLSX, right click the date dimension, click Format cells..., the type is General.


The symptom is by design.


See Also

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


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, sap analyst cloud , KBA , LOD-ANA-DES , Story Design & Visualizations , Product Enhancement


SAP Analytics Cloud 1.0