Help in Multiple data sources...

[gops210]

Hi,

I need to import tables from multiple data source in FM model for ex

Database A - 10 tables
Databse B - 10 tables


can i join these two databases using a common column

is it possible to join two different databases..please help...

[blom0344]

Yes, you can use multiple database-sources in FM if you have dimensions that allow for joining the data.
The restriction is that Cognos needs to fetch data for both sides first and combine them on the server. This could involve performance issues. We use this on a number of occasions and it seems to work okay for us.