SAP Knowledge Base Article - Public

3329033 - Null Values for Date Dimension Rejected when importing data in a Model in SAP Analytics Cloud (SAC)

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

  1. In SAP Analytics Cloud, go to the Schedule Import.
  2. 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:
       
    1. Go to the Data Management screen and edit the import.
    2. In the grid view, replace all null value with empty string ('')
    3. Go to the Import to do the validation.
    4. 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