Symptom
- Importing data in a Model started failing.
- Previously importing data in the Model worked without issue, in SAP Analytics Cloud.
Environment
- SAP Analytics Cloud 2023
Reproducing the Issue
- In SAP Analytics Cloud, go to the Schedule Import.
- In the Rejection Summary, notice the import failed for null values for Date dimension are rejected.
Cause
- Null data for the Date Dimension caused the error when importing data.
Resolution
- When the data import fails due to NULL values, to import the data successfully:
- Go to the Data Management screen and edit the import.
- In the grid view, replace all null value with empty string ('')
- Go to the Import to do the validation.
- Run the Import again.
Keywords
SAC, Error, Issue, Data, Model, Rejected, Null, Values, Date, Dimension , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud all versions