How to implement Union and Join operations in OBIEE
715281Aug 3 2009 — edited Aug 3 2009Hi all,
Am new to OBIEE. Can some one tell me the right place to create Union and Joins in OBIEE....
Do i need to create Union or Join in Oracle(DB level) or do i have the option of creating Union/Join in Physical layer or BMM layer. I tried creating a union in Physical layer,but when i check the the data in presentation layer,i see only data from 1st table.
Thanks you
Praveen