Cognos Analytics

There are 2 datasources when we run a cognos report for selection. But only one is to be used which has the required table in that database.When we schedule a cognos job, cognos is picking the first datasource which doesn't have the required table in it. The datasource names are similar with convention and a suffix being attached to second datasource( example  abc, abc_dev) . I have explicitly given the datasource selection in the schedule prompt for values option also. But still when the schedule runs, the picks the first datasource(abc) and throws the error that table is not present in the database. How can we make sure that right datasource is automatically selected during the schedule??

Did anybody come across this kind of issue using the multiple datasources with the schedule action?

There are 2 datasources when we run a cognos report for selection. But only one is to be used which has the required table in that database.When we schedule a cognos job, cognos is picking the first datasource which doesn't have the required table in it. The datasource names are similar with convention and a suffix being attached to second datasource( example  abc, abc_dev) . I have explicitly given the datasource selection in the schedule prompt for values option also. But still when the schedule runs, the picks the first datasource(abc) and throws the error that table is not present in the database. How can we make sure that right datasource is automatically selected during the schedule??

Are you talking about 2 datasources? Or 2 connections in 1 datasource? I suppose the latter! In that case give the user-account, that runs the schedule, only read and execute rights on the wanted connection. You have to give the user-account also traverse rights on both connections, otherwise it fails to run.

If the issue is 2 datasources, then my guess is that the wrong datasource is hard-coded in the package available, find this in the xml. Has to be fixed in the model.

Did anybody come across this kind of issue using the multiple datasources with the schedule action?

There are 2 datasources when we run a cognos report for selection. But only one is to be used which has the required table in that database.When we schedule a cognos job, cognos is picking the first datasource which doesn't have the required table in it. The datasource names are similar with convention and a suffix being attached to second datasource( example  abc, abc_dev) . I have explicitly given the datasource selection in the schedule prompt for values option also. But still when the schedule runs, the picks the first datasource(abc) and throws the error that table is not present in the database. How can we make sure that right datasource is automatically selected during the schedule??