Symptom
- A HANA CompositeProvider (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 BW/4HANA All versions
- SAP NetWeaver All versions
Product
Keywords
RSQBW 143, RSQBW143, wrong results, COPR, ISET, InfoSet, Additional Grouping before Join, HANA, composite provider, compositeprovider non unique,wrong values,cube,composite provider data preview,composite provider,hana composite provider,hcpr,hana data preview,incorrect results,list,listcube , KBA , BW-BEX-OT-HCPR , CompositeProvider Query , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-DBIF , Interface to Database , BW-WHM-DST , Data Staging , BW4-AE-CORE , Core Services , BW4-DM-HCPR , Composite Provider , BW4-AE-DBIF , DB Interface Data Manager , 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