COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: vivek_cyno on 26 Sep 2012 09:09:29 AM

Title: Update the reports if package is modified
Post by: vivek_cyno on 26 Sep 2012 09:09:29 AM
Hi,

Someone could help!!

I have a package and we have done few modifications in the package..I have 200 reports created using the same package.

Can you please help me how to update all the report in one go..Your help is much appreciated.

Thanks
Cyno
Title: Re: Update the reports if package is modified
Post by: charon on 26 Sep 2012 11:24:23 AM
Are you getin error messages at all? or are these minor changes that does not affect your reports?!
Did you save the package under the same name as the old package?

I ve never created jobs that checked all my reports, but one thing you could in, e.g. you have changed some data item paths, to copy out the xml and search and exchange the paths...works much faster if your reports are complex and you need to adjust them in several parts.
Title: Re: Update the reports if package is modified
Post by: vivek_cyno on 29 Sep 2012 07:36:47 AM
Hi.

Thanks much for your reply..

I just modified few query calculation in my package and republished it.

Now, I have 200 reports using the same package..need to update all those 200 reports..

Please help me.
Title: Re: Update the reports if package is modified
Post by: tjohnson3050 on 29 Sep 2012 05:49:07 PM
We have a third party tool named Meta-Manager that allows mass updates of reports when you change a package:

http://www.bspsoftware.com/MetaManager

IBM also has a tool designed to help with report migration called Lifecycle Manager.  I haven't used it, but I know it can at least show you which of the reports will break with the package changes.

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_upgr_mngr.10.1.0.doc%2Fug_upgr_mngr_id240how_um_works.html

Title: Re: Update the reports if package is modified
Post by: bdbits on 01 Oct 2012 11:38:50 AM
There is also the Dynamic Report Specification Updater Diagnostic from IBM. It is not recommended for use on production systems due to user error potentially corrupting all of your reports.  :o

http://www-01.ibm.com/support/docview.wss?uid=swg24021248
Title: Re: Update the reports if package is modified
Post by: cognostechie on 01 Oct 2012 04:27:31 PM
I second charon on this. The questions is 'Why do you think that those 200 reports should be updated?' Is it because somebody told you so?

The modification in the package should be done in a way that it does NOT cause the reports to break. The only time reports need to be updated is when some modification is made which will cause the reports to stop working (which is not the correct way of doing it anyway unless it was decided earlier to do it that way for a massive re-vamp or something like that)