Symptom
Wrong Values when extracting from HCPR to ADSO: Each line result is multiplied by 11.
After checking the data in the source HCPR XXXX and you found the following warning:
**************************************
Ambiguities cannot be resolved without the analytic engine
Message no. RSQBW143
Diagnosis
The InfoProvider contains nested ambiguous joins that cannot be completely resolved in queries without the analytic engine (OLAP).
This situation occurs if an InfoProvider in linked in multiple directions, and the join fields for the several joins are not identical.
System Response
The InfoProvider can still be activated and used however. Where queries are made without the analytic engine (using list cubes, or the external data manager interface RSDRI for example) ambiguities can occur, despite the local aggregation.
**************************************
Read more...
Environment
- SAP NetWeaver 7.4.
- SAP NetWeaver 7.5.
- SAP BW/4HANA
Product
Keywords
KBA , BW4-DM-TRFN , SAP HANA execution in Transformation and DTP , Problem
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.