SAP Knowledge Base Article - Preview

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

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 2.0.
  • SAP BW/4HANA 1.0.

Product

SAP BW/4HANA 2.0

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 ONE Support launchpad (Login required).

Search for additional results

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