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

    Join issue with OBIEE 11g

    4026497

      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.