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

Data source for Oracle database

Started by tupac_rd, 12 May 2008 08:17:21 AM

Previous topic - Next topic

tupac_rd

Hi,

We are using Cognos 8.3 and our reporting database is Oracle. When creating a datasource, what is the best practice - Should we create one datasource per database in Oracle or should we create one datasource per schema within a database.

Ty Clabbers

I am not completely sure but i think that if you are creating a report on using multiple datasources the joining will be done on the Cognos server. If you have only one datasource the joining will be done at the database. IMHO it is always better to let the database do the joining. Our Cognos servers have other things to do.