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

How to reapply the new package to all reports in a folder

Started by Daljith, 26 Dec 2014 12:51:19 PM

Previous topic - Next topic

Daljith

Currently there are 20 reports in UAT. Everytime DEV team sends a report with the package, I move it to Reports folder but somehow rest all reports become invalid and I have to open all the reports to reapply the package to validate the reports. I heard from one of my senior that it should happen automatically when I move a new package to the folder but it does not happen and everytime just to move one new report, I have to open rest of the reports to reapply new package. I have checked executing the reports and it fails if I do not reapply the new package.

Please suggest if we have a shortcut for that or how can I fix this issue.

Raghuvir

Quote from: Ana on 26 Dec 2014 12:51:19 PM
Currently there are 20 reports in UAT. Everytime DEV team sends a report with the package, I move it to Reports folder but somehow rest all reports become invalid and I have to open all the reports to reapply the package to validate the reports. I heard from one of my senior that it should happen automatically when I move a new package to the folder but it does not happen and everytime just to move one new report, I have to open rest of the reports to reapply new package. I have checked executing the reports and it fails if I do not reapply the new package.

Please suggest if we have a shortcut for that or how can I fix this issue.

Hi Ana,

Request you to try the below steps.

1. Place all the reports in one folder that you wish to change the association package.

2. Generate deployment archive of the folder using Export wizard. This pushes all the report definitions in one xml file.

3. Pick up the deployment archive at <COGNOS Installation Path/c8/deployment>, unzip and examine the xmls. (will vary as per the installation location and the version of cognos)

4. Once you find the xml that contains all the reports, open it in any editor. Now, search for the package name and identify the pattern you need to replace. Now, simply replace all the instances of package name using that pattern.

5. Post all modification put the file back in zip and brought them back in COGNOS using Import wizard.

6. That's it! You are done. Now, you have all the reports back with the Report Package changed to the desired one.

Note: While importing, you might want to change the 'destination' of folder so that it creates a new copy of reports. So, in case of any issue, you still have the original folder intact.

Regards


cognostechie

@ ana - Use the process suggested by Raghuvir at your own risk.

First of all this is not a process but a manual way of changing the package name and secondly, you will take the risk of corrupting the reports. If you had to manually examine the xmls then you might as well change the package name in the report properties manually.

Daljith

Thanks Raghuvir and thanks cognostectie for the response.

I tried the option, its working fine but yes it seems little risky.
Do we have any other easy option also  or easy way to do this.
Please suggest.