SAP Knowledge Base Article - Public

3630265 - Null value is not allowed for single column dimensions error happens when creating the new model type and import some data with null value of the dimension attribute

Symptom

Null value is not allowed for single column dimensions error happens when creating the new model type and import some data with null value of the dimension attribute.

Environment

  • SAP Analytics Cloud 2025.8.12 (Client)
  • SAP Analytics Cloud 2025.8.6 (Server) 

Reproducing the Issue

    1. Create a new model type using the MDMAudit query.
    2. Change the data types as needed.
    3. Save the model.
    4. Go to Data Management
    5. Click the "Set Up Import" in the Import Jobs
    6. Map the objects.
    7. Review Import
    8. Dimension Restrictions - Null value is not allowed for single column dimensions.

Cause

This is a by design behavior.

Resolution

The restriction rule is added because single column dimension (aka fact table dimensions) do have a restriction that prevents NULL values.

 

Keywords

replaceNullWithEmpty, formula, classic , KBA , LOD-ANA-ML-DE , SAC Data Wrangling , Problem

Product

SAP Analytics Cloud 1.0