2404131 - Excel Date format is not imported in SAP Analytics Cloud

SAP Knowledge Base Article - Public

2404131 - Excel Date format is not imported in SAP Analytics Cloud

Symptom

Date format is changed when importing Excel file into SAP Analytics Cloud (SAC).

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Change Regional Settings on a computer to be different from US, example Brazil. (The date formal for Brazil will be in "DD/MM/YYYY" format).
  2. Create an Excel workbook with date as one column. By default the date will be in "DD/MM/YYYY" format.
  3. Save the Excel file.
  4. Create a Model within SAC by importing the Excel (XLSX).
  5. The date will be displayed in "MM/DD/YYYY" format. 

Cause

This is by design, as the date format within Excel is for display purposes and it takes the system default to display. The format is never saved when creating an Excel file.

Resolution

Workaround:

Manually set the date format in the Excel file. Then save the Excel file with the custom date format.

When you import the file, the format will be saved with Excel and it will be displayed in the saved format in the data integration stage.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud 4 Planning, HCP, C4A, BOC, SAP BusinessObjects Cloud, bobj, XLS Date, XLSX, excel, custom date format
, KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0