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

• 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".

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

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

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.        

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

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)

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