SAP Knowledge Base Article - Public

2803423 - Data cannot be imported into existing model without fixing data quality issues in SAP Analytics Cloud

Symptom

Since SAP Analytics Cloud version 2019.07 the following behavior occurs in SAP Analytics Cloud (SAC):

  • Data cannot be imported into existing models without fixing data quality issues, because of the below error:
    "Full data validation cannot be performed before fixing data quality issues for <dimension contains data quality issues>"
  • Before SAP Analytics Cloud version 2019.07 the validation was possible even if there were data quality issues. Rows which contained issues were removed at data import.

Environment

SAP Analytics Cloud 2019.9.4

Reproducing the Issue

  1. Logon to SAP Analytics Cloud.
  2. Import data to an existing model.
  3. Notice the data quality issues.
  4. Click "Finish Mapping".
  5. Notice the error: "Full data validation cannot be performed before fixing data quality issues for <dimension contains data quality issues>"

Cause

Hierarchical dimensions could not be imported without enabling "allow loading data to non-leaf node" in the side panel.

Resolution

Enable "allow loading data to non-leaf node" in the side panel.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-BR , SAC Boardroom , Bug Filed

Product

SAP Analytics Cloud 1.0