If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report to run with multiple datasources at a time

Started by Shailaja0520, 21 Apr 2011 06:05:27 AM

Previous topic - Next topic

Shailaja0520

Hi,

I have 2 data sources from 2 different databases.

Can we run the report with multiple datasources at a time? If yes how to achieve this?
or everytime it  will prompt the user to select the datasource while we run the report?


Yunus

If both data sources are referenced in a single package you can report from either one or both at the same time.  That is if you have a join between the two.

Arsenal

I assume you meant one datasource with 2 nodes/database connections because a report/package cannot have 2 different datasources. But a datasource can have 2 different database connections/nodes within it.

And yes, doing so will prompt the user to choose a database everytime you run the report.

if your users are neatly spread up into two groups, one for each database, then you can set security appropriately on each node and they won't get prompted, as Cognos will automatically pick up the database connection based on the group the user belongs to