Symptom
- A HCPR 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.
- When such a HCPR is used as a source of a DTP, the extracted data is incorrect.
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, composite provider, compositeprovider , KBA , non unique , wrong values , cube , composite provider data preview , composite provider , list , listcube , hana composite provider , hcpr , hana data preview , incorrect results , BW-BEX-OT-HCPR , CompositeProvider Query , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-DBIF , Interface to Database , BW-WHM-DST , Data Staging , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview