Analytics Software

Hi,

I want to join two tables that are in different databases. I want to join these tables on some condition and then be able to see data from both of them in the reports.


Table 1 - columns A1, B1, C1
Table 2 - columns A2, B2, D2

Currently what we tried is
1. create foreign key constraint between the two tables in the physical layer. Map A1 to A2, B1 to B2.
2. create a join of two tables in BMM layer and then port that to presentation layer and then make report using these columns.
OR
try the approach as described on link http://oraclebizint.wordpress.com/2008/03/19/oracle-bi-ee-101332-cross-database-joins/

in both the above mentioned ways, we are not able to see join of two tables. The link mentioned above doesn't work as we tried it multiple times already.

We are able to see individual data from each table, but when we try to see data from them together, we get error.

Can someone help us with this problem.

Please email me on amitkgarg@gmail.com if you need more info as i cant paste the confidential data here on the forum.

Thanks in advance,
Amit