2372430 - Ambiguous Joins: LISTCUBE may display incorrect values | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2372430 - Ambiguous Joins: LISTCUBE may display incorrect values

Symptom

  • A CompositeProvider uses a join condition with one of the following cardinalities: 1:n; n:1; n:m. When you check the data with the help of transaction LISTCUBE, incorrect values are displayed.
  • When running transaction LISTCUBE or checking the definition of a HCPR, the warning 'Ambiguities cannot be resolved without the analytic engine' (Message no. RSQBW143) is issued.
  • The same behavior occurs when extracting data from HCPR with DTP load. 

Read more...

Environment

  • SAP NetWeaver 7.4
  • SAP NetWeaver 7.5

Product

SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

RSQBW 143, RSQBW143, wrong results, COPR, ISET, InfoSet, Additional Grouping before Join, HANA , KBA , hana data preview , list , incorrect results , listcube , composite provider data preview , hcpr , cube , non unique , hana composite provider , wrong values , BW-BEX-OT-HCPR , CompositeProvider Query , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-DBIF , Interface to Database , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.