SAP Knowledge Base Article - Public

3511149 - The Blending mapping is wrongly defined : Subquery 'CUBE:t.x:xxxxxxxxxxxxxxx' returned an error. Please check the query definition error occurs in SAP Analytics Cloud

Symptom

  • The table has two Live BW model used and there is blending defined
  • When some special dimensions are added to table columns, error occurs as the following:
    • The Blending mapping is wrongly defined : Subquery 'CUBE:t.x:xxxxxxxxxxxxxxx' returned an error
    • Caught exception : exception 42018: Internal error occurred while processing : Entity tuple array sizes aren't equal.
      Try to re-open the story or refresh the browser.
  • If add the dimensions into table rows, it may work fine.

Environment

SAP Analytics Cloud 2024.15

Reproducing the Issue

  1. Create a story and add a table.
  2. Add two live BW model as data source and edit the data link to define the blending.
  3. Add some dimensions into Rows and Columns.
  4. Error occurs as:
    • The Blending mapping is wrongly defined : Subquery 'CUBE:t.x:xxxxxxxxxxxxxxx' returned an error
    • Caught exception : exception 42018: Internal error occurred while processing : Entity tuple array sizes aren't equal.

Cause

The issue has been forwarded to development for further checking.

Resolution

The issue has been forwarded to development for further checking.

Keywords

SAC, stories, analytics, design, link, linked , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0