Hi gurus,
How can i switch my reports between two schemas like prodiction data and test data.
thanks in advance
K.M
There was an IBM technote on doing this, but I can't seem to find the right search terms to dig it up.
Regardless, I do remember that it was messy and a PITA to setup. It would be easier if you had 2 data sources and 2 packages, then you can just re-link your report back and forth. Much easier to set this up.
Even better practice is to have a Development Cognos environment and a separate Production env where the reports once developed and accepted can be published to production.
Is it oracle or sql?
For SQL, just create 2 data connections inside your data source.
When you run the report, it'll prompt you which one to use.
It'll work with Oracle as well if the catalog names are different.