Join issue with OBIEE 11g

Question

HI

I am using oBIEE 11.1.1.9.0

I am defining join between two tables at RPD. But when i am creating report and see the physcial query joins are mismatching.

I am wondering how this can be done. I have tried creating new subject area , using alias tables but again same issue.

I am doing as below.

Table1 and table2

join at RPD i am defining as Table1.A=Table2.B and Table1.B=Table2.A

After deploying RPD and when checking for physical query related to this, it is getting join as below

Table1.A=Table2.A and Table1.B=Table2.B

I tried changing multiple times, but i have same issue.

Can anyone suggest me as how can i get resolve this issues.

SonPat99 · Answer

Please post a screenshot of both your Physical join showing fact and dim, condition showing your join condition and physical sql generated from OBIEE.

Gianni Ceresa · Answer

Would you mind to post a screenshot of your join(s) in the RPD? Because joins can be defined in various places and they mean different things, so by "join in the RPD" it's a bit too generic.

And although OBIEE can change joins a little to improve queries, it would never really exchange 2 joins without a reason.