SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • 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.

Cause

  • The symptom is by design.

Resolution

  • After exporting to XLSX, if the Date format is expected, would you please provide a feature enhancement by referring below KBA.
    2424376 - How do you create an enhancement request for SAP Analytics Cloud?
  • The export function does not change the underlying data type.  
    A value remains a value and a string remains a string.  
    If a formatted date value is exported to Excel, yes the format is changed to general but the underlying value is still sortable as a number and can be used in math operations.
  • Export to CSV type as workaround.

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

Product

SAP Analytics Cloud 1.0