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...
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.