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