Symptom
Invalid date when import a excel file which include scientific notation in SAC
Environment
SAP Analytics Cloud (Enterprise) 2020.7.0
Reproducing the Issue
- Logging into SAC.
- Click Main Menu.
- Click Create.
- Click Model.
- Click Import a file from your computer.
- Click Select Source File, select an excel file which include scientific notation, the attachment Sample.xlsx can be used.
- Click Import.
- Click OK.
- In Draft Data, select the file which is just imported.
- Click Validate Data, in the Mode Requirements, the column which include scientific notation is detected with data quality issues.
Cause
When a file is uploaded we sample the first 5000 rows of the file to infer data types of the columns (One reason is related to performance). If there is no data in the first 5000 rows in the file, then will facing data quality issue.
Resolution
Moving a row with the decimal numeric value for columns which are facing data quality issue into the first 5000 rows of the excel file.
Keywords
KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Product Enhancement
Product
SAP Analytics Cloud 1.0
Attachments
Sample.xlsx |