Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Join issue with OBIEE 11g

Received Response
1
Views
2
Comments
4026497
4026497 Rank 1 - Community Starter
edited Aug 13, 2024 5:24PM in Oracle Analytics Cloud and Server

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

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