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