how to switch the package between 2 schemas

[madhancog]

Hi gurus,
  How can i switch my reports between two schemas like prodiction data and test data.

thanks in advance
K.M

[Grim]

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.

[Suraj]

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.