SAP Knowledge Base Article - Public

3138388 - Date format in the exported XLSX is not matching the SAC user profile settings in SAP Analytics Cloud (SAC)

Symptom

  • Date format in the exported XLSX is not matching the SAC user profile settings.
  • Where model is based on direct live data connection to SAP HANA.

Environment

  • SAP Analytics Cloud (Enterprise) 2021.20.12
  • SAP HANA 2.0

Reproducing the Issue

  1. Login to SAC.
  2. Open the Story with a table that is containing date values.
  3. Exporting Table Data as an XLSX File
  4. Select option "XLSX-Export with Scope = All" => the date formatting in exported MS Excel is e.g. MMM d,yyyy, which is not the same as in SAC table (e.g. English, date formatting as dd.MM.yyyy in SAC user profile). Even not the same, that is set on the local Operating System (e.g. region Germany, format dd/MM/yyyy).

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, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem

Product

SAP Analytics Cloud 1.0