SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

  • 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

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

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

Product

SAP Analytics Cloud 1.0