2 Replies Latest reply on Sep 11, 2019 3:58 AM by SonPat99

    Join issue with OBIEE 11g




      I am using oBIEE


      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.