Hi All,
I have mutiple data sources like MY SQL and Oracle. I want to import tables from these 2 different data sources and make relationship between these 2 different data source tables and I want to create new query subjects by using the tables from these 2 different data source table. Is it possible.
If its possible what to do create new query subjects from the 2 different data source table.
Your help will be appriciated.
Sarayu
1/ make both connections in cognos
2/ make a new framework manager project
3/ import table from both connections
4/ modelize the link (=relation)
5/ add a new query subject
6/ add a package & publish
7/ do whatever you want with your data.
it will work but I am not sure cognos will do a great job doing the link (index are in your database server not in cognos server...)
Hi nonoo,
Thanks for your quick response.
Do we need any common table like a confirmed dimenstion to join the 2 different schemas (means 2 different data sources)
Do we need any common tables or common columns to join the 2 different data source tables.
To join the data sources, you will need at least one common item in each. You can then select these items and create a relationship between them.
Regards,
MF.