Ambiguities cannot be resolved without the analytic engine

What causes this issue?

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.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.