SAP Knowledge Base Article - Public

3584714 - SAP Analytics Cloud: Rejection of Null Values in Dimensions During Import Jobs

Symptom

  • SAP Analytics Cloud (SAC) import jobs have been rejecting rows with null values in dimensions.
  • This issue has resulted in incomplete data being loaded into models.
  • The error message associated with this issue is "Single column dimension member does not exist".

Environment

  • SAP Analytics Cloud > Data Preparation > Datasets and Models
  • SAP Analytics Cloud Enterprise 2025.1.8

Reproducing the Issue

  1. Access SAP Analytics Cloud
  2. Navigate to the model.
  3. Review the rejection summary for import job.

Cause

In the past, if the incoming data had a null value, the data import would not say that the row is rejected, but it wouldn’t insert the row to the model either. 

It created some confusion and inconsistent behavior. Null value is not meant to be accepted by the model. 

So recently the software was enhanced so that the NULL value is rejected properly and communicated to the user.        

Resolution

You can do a transform to replace null by “”, then the import works. 

See Also

Refer to the following SAP Note for additional information: 3329033 - Null Values for Date Dimension Rejected when importing data in a Model in SAP Analytics Cloud (SAC)

Keywords

SAP Analytics Cloud, SAC, import jobs, null values, dimensions, rejection, data loading, error message, column dimension member does not exist. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions