SAP Knowledge Base Article - Public

2781427 - Date data in Microsoft Excel file is not recognized correctly when create model in SAP Analytics Cloud (SAC)

Symptom

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

  • When create a model in SAC using the Excel file which is generated by third party application EveryAngle, the date data is not recognized correctly, like the data 03/04/2019, only the year part 2019 is recognized, for the day and month, not recognized, like below: 

 Import_Data_Date_Format.PNG

  • If edit any part of the original Excel file, like click or edit any cell, then save and import file again to create model, the date data will be recognized correctly:

 Date_Correct.PNG

Environment

  • SAP Analytics Cloud 2019.6.3

Reproducing the Issue

  1. Create a model in SAC, select Import a file from your computer.
  2. Select the Excel file generated by EveryAngle as source file, click Import.
  3. Notice that only year part of the original date data is recognized in the column.
  4. Edit any part of the original Excel file, like click or edit any cell, then save again.
  5. Reproduce the 1-3 steps again, the date data is recognized correctly.

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, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0 ; SAP BusinessObjects Roambi, cloud edition 71