SAP Knowledge Base Article - Public

2804868 - Excel date type data cannot be recognized correctly when creating model in SAP Analytics Cloud

Symptom

  •  Excel date type data cannot be recognized when creating model in SAP Analytics Cloud
  •  Partial date type data got recognized as invalid data format

Environment

  •  SAP Analytics Cloud 2019.11.1

Reproducing the Issue

  1. Create new model with specific excel file containing Date type data.
    >>Got "Invalid data format" for partical Date type data.
  2. Delete some data to reduce the data volume without any change on data format.
  3. Create new model with modified excel file.
    >> No error detected.

Cause

The issue is under investigation by Development team.

Resolution

The issue is under investigation by Development team.

See Also

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

Keywords

date, DATE, DD/MM/YYYY, MM/DD/YYYY, format, 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, excel, jp , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP S/4HANA Cloud 1905