SAP Knowledge Base Article - Public

2849768 - Unable to display correct values with link dimensions on SAC

Symptom

When creating a story with different import Models with linked dimension, the below error happens:

Caught exception : exception 42218: The Blending mapping is wrongly defined : Subquery 'CUBE:t.3.CF3X2QEEFYMMBH2L7XXXXXXXX:CF3X2QEEFYMMBH2L7XXXXXXXX' returned an error. Please check the query definition

Environment

  • SAP Analytics Cloud 2019.15.12 

Reproducing the Issue

  1. Create 2 BW imported model .
  2. Create story based on 2 model and create filters and linked dimensions.
  3. Refresh the story and the data could not get displayed with the below error:

    Caught exception : exception 42218: The Blending mapping is wrongly defined : Subquery 'CUBE:t.3.CF3X2QEEFYMMBH2L7XXXXXXXX:CF3X2QEEFYMMBH2L7XXXXXXXX' returned an error. Please check the query definition

Cause

This incident is currently under development investigation.

Resolution

This incident is currently under development investigation.

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-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0