SAP Knowledge Base Article - Public

3044844 - Error 'The Blending mapping is wrongly defined' in SAP Analytics Cloud (SAC)


After creating a chart which uses a blended datasource (Live BW merged with an Imported Excel Model), you create a calculated measure that references another calculated measure which is not being displayed in a chart. The chart then gives the error:

Unable to retrieve data from the data source.

The Blending mapping is wrongly defined : Subquery 'CUBE:t.8.A1B2C3EFGHIJKLM' returned an error. Please check the query definition

If you add the non-displayed measure back into the chart, then the error goes away.


  • SAP Analytics Cloud (Enterprise) 2021.2.15

Reproducing the Issue

  1. Create a new Story based on a Live BW connection
  2. Add an import model based off of Excel to the story
  3. Add a chart to the story with the Live BW connection as the primary datasource
  4. Add the import model to the chart
  5. Create a Calculated measure that references a field from the Live BW connection
  6. Create a second calculated measure that references the first calculated measure.
  7. Remove the first calculated measure from the chart
  8. Note the error appears


This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

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


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0