How to report on 2 datasets across different database in OBIEE

Hello Today I want to talk about this feature in OBIEE that allows you to do cross-db reporting, which I think is pretty cool. Say you have 2 different result sets, they could be 2 tables or could be 2 queries. Now I want to see an OBIEE report that joins these 2 result sets based on some common dimensions, so how do we do it? First of all, these 2 objects will be residing on different physical folders with different connection pools, this makes...

Read More