Self Join in OBIEE RPD

Question

Hi Team,

We have 3 tables Table1, Table2, Table3 in OBI RPD is it possible to have join condition like below

Table1 A

Left join

Table2 B

On A.num= B.No

Left join

Table3 C

On A.num=C.NO

Left join

Table2 D

On NVL (B.ID1, C.ID2) = D.ID3

Left join

Table3 E

On NVL (B.ID1, C.ID2) = E.ID3

OBI version we are using 12.2.1.4.0

Here we have 3 tables (Table1, Table2, Table3) and we are doing self-join for Table2 and Table3 and applying NULL in the join condition.

Looking for some basic idea how to achieve this RPD.

Thanks,

[Deleted User] · Answer

I've closed this thread.

@User_2V6CO please open a new thread where you can manage incoming responses yourself. State your issue precisely and fully with code examples or screenshots where appropriate.

https://community.oracle.com/customerconnect/kb/articles/7-how-to-ask-a-good-question

https://support.oracle.com/knowledge/Support%20Tools/2299812_1.html

Gianni Ceresa · Answer

@User_2V6CO ,

You should start by posting a new question (instead of replying to an abandoned 3 years old thread), providing enough details about what you want to do, what did you try, what was the result etc. Also always include product name and version.

Consider that people will spend the same amount of time you invested in writing your question in replying: you write 5 words taking you 10 seconds, why would somebody invest 5 minutes of their time to write a full reply?

User_2V6CO · Answer

How to achieve join with NVL function in rpd?Plz help