3132073 - Extraction from HCPR to ADSO leads to keyfigures being multiplied

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.

**************************************

• SAP NetWeaver 7.4.
• SAP NetWeaver 7.5.
• SAP BW/4HANA

KBA , BW4-DM-TRFN , SAP HANA execution in Transformation and DTP , Problem