Report Pointing to different Data Source

[akhattri]

Gurus,

I have a situation where I have a single development environment for Cognos and I want to have it pointed to 2 data sources (Development ODS and UAT ODS). The functionality I need is, if once the developers create the report and the report is to be tested by users, the report should ask at run time which data source should the report pull the information from( DEV_ODS or UAT_ODS)  since the data in both these instances will be different.

I am unable to figure out how to perform this using Administrative tools. If anybody had a similar situation or had worked on it, kindly provide your valuable input.

Thanks.

[blom0344]

For a given datasource create multiple connections. In the properties setting of the connection you can assign the  proper parameters to the actual database addressed. (like Servername,databasename,connectiontype,isolationlevel) You can also assign groups / users that are authorized to use the connection and the type of rights.

At runtime, the user will have to choose the connection (cause the is more than 1 connection assigned to the datasource)