You have created a joined data source consisting of 3 or more data sources. You are sure that the join conditions are correct, however the Check of the data source returns the following errors:
Join member pair on right side not supported
Join Pair JOIN_PAIR_01 is not used
Join Pair JOIN_PAIR_02 is not used
Operands of join condition JOIN_CONDITION_01 need to be part of join pair JOIN_PAIR_01
Reproducing the Issue
- Go to the work center Business Analytics, view Design Data sources.
- Click on New > Joined Data Source
- Add some data sources. For this example, let us assume you want to join Account Master Data, Territory Team, Account Contact Data and Territory Account Mapping. Add these data source in this order.
- Set the join conditions on the account and territory fields.
- Click on Check.
You will get the errors mentioned above.
The first 2 data sources you added were Account Master Data and Territory Team. They have no join conditions between them, i.e. Territory Team is only linked to Territory Account Mapping. It is important the to add the data sources in the sequence in which there is some join to the previously added data source. Otherwise, while building the join conditions in the backend, some join pairs may go wrong and the error message will be raised.
You can use the same data sources and join conditions for your data source, however please add the data source in a different order: Choose a sequence in which there is some join to the previously added data source. In case of an inner join this will not make a difference to the displayed content, but it will make sure all joins can be built correctly. In case of a left outer join, you can leave the anchor data source as it is, and arrange the sequence accordingly. For screenshots to illustrate this, please check the attachment of this document.
KBA , SRD-CC , Cross Components , How To