COGNOiSe.com - The IBM Cognos Community

Hi All,

I am creating query subjects using the queries containing joins from multiple databases (2 or 3) provided by a client.

The requirement is , They want a prompt for the schema datasource while executing queries.

Since Currently they are using 3 databases say A, B, C.
They want the same queries to fetch data from D, E, F resp

All tablenames, structures are same in A,B,C with D,E,F.

Any guidance is appreciated.

Thanks in advance

Each datasource can be used with 1 or more connections. The connection points to the required database. This way , at runtime you are prompted to choose a connection IF more than one is defined. Use Cognos administration to add a connection to a datasource

Hi Blom,

Thank you for your reply.

I am havin a qury which fetches data from multiple schemas having left outer join
So how Do I go about it.

A query containing one schema is working properly but need about multiple schemas in 1 query

Thanks

If you prefer to stay away from using native SQL within query subjects, then you would need additional datasources. In the datasource definition you can define the specific schema name

Hi Blom,

Thanks for your reply. I will try and let you know.


Thanks again