Oracle Business Intelligence

Products Banner

Self Join in OBIEE RPD

Closed
34
Views
3
Comments
User_JZKI6
User_JZKI6 ✭✭✭

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

This discussion has been closed.