Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cschnu on 18 Jun 2009 02:24:44 PM

Title: Changing report package
Post by: cschnu on 18 Jun 2009 02:24:44 PM
I have an existing report in which i need to change the package it is linked to. The report needs to be migrated from Package A to Package B. Package B contains all the views that package A does as well as more views that are needed. Is there a quick way to find and replace package A name with package b name. So any all the report queries change [PackageA].[View].[Field] to [PackageB].View.Field]?
Title: Re: Changing report package
Post by: uttam.mistry on 18 Jun 2009 03:06:18 PM
i used do it as follows without problem:

1. copy report to clipboard (from options)
2. open notepad or any good editor
3. past report in notepad
4. find and replace [PackageA].[View] with [PackageB].[View]
5. select all and copy
6. in report studio - options- open report from clipboard
7. change the report package from A to B (i think you know how to it)
8. save report ..

hope this helps
Title: Re: Changing report package
Post by: Universe09 on 18 Jun 2009 10:56:20 PM
You can also create a exact copy of the report then follow this steps:

1: Open File Menu
2: Click Report Package
3: Select the New Package
Title: Re: Changing report package
Post by: cschnu on 19 Jun 2009 01:13:34 PM
Quote
You can also create a exact copy of the report then follow this steps:

1: Open File Menu
2: Click Report Package
3: Select the New Package

Right but it won't change all the references from the old package to the new package.
Title: Re: Changing report package
Post by: Gollapudi on 19 Jun 2009 02:24:29 PM
Hi,

Just go to Cognos Connection where your report exist, and go to its properties there you can see the Package name based on which the report is working, you can change it, this is the actual way, the other ways has been given by our friendz in their previous mails.

Thanks,
Gollapudi.
Title: Re: Changing report package
Post by: cschnu on 22 Jun 2009 01:55:13 PM
QuoteHi,
Just go to Cognos Connection where your report exist, and go to its properties there you can see the Package name based on which the report is working, you can change it, this is the actual way, the other ways has been given by our friendz in their previous mails.

Thanks,
Gollapudi.

Yes but you will get the error below, if you don't change all references to the current package you are linked to. The notepad method is what I was looking for, thanks.
Code Select
QE-DEF-0030 Expression parsing error.
QE-DEF-0359 The query contains a reference to at least one object 'PackageA.View.Field' that does not exist.
Text only | Text with Images