OBIEE Report Issue – Incorrect Join Path Being Used in Analytics

User_HQ9TE

Hi Everyone,

We have created two join paths in the RPD. When creating an analysis in BI:

• The first join path is being picked up in Analytics, but it returns no data.
• The second join path has valid data, but it is not being selected by BI when the report runs.

We would like to ensure that the second join path (which returns data) is used to generate the report. Could you please help us understand how to configure BI to use the correct join?

Thanks for an advance.

BI_QUERY.png