Joining using multiple columns across two tables
706203Jun 11 2009 — edited Jun 12 2009Hi all,
There are two tables T1 with columns c1,c2,c3 and T2 with columns C1,C2 and C4.
I need specify join between these tho physical tables in OBIEE admin tool iin such a way that ,
1) if the the output report has C1 column in that , the tables should join using C1
2 ) if the output table has C2 ,join should be based on C2
3) If the output tables have both the columns , join be on C1 AND C2.
Is there a way we could specify these ?
The only way i could think of for this is to split these into multiple views ( 2 views having C1 and C2 seperately ) and joining them.
What is the right way to approach such a scenario ?
Thanks.