Categories
Self Join in OBIEE RPD
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,
Answers
-
How to achieve join with NVL function in rpd?Plz help
0 -
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?
1 -
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.
0
