COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => SDK => Topic started by: TheBrenda on 26 Aug 2013 02:46:13 PM

Title: Can you update report definitions with SDK?
Post by: TheBrenda on 26 Aug 2013 02:46:13 PM
We changed some field names in out last release. We changed our canned reports/queries but the client's ad hoc reports/queries still have the old field names. I was going to write a query to change the field names in the cmobjprops7.spec directly but am a bit nerveous because I cannot find anyone who has done this. Does anyone know a specific  reason why I should or should not directly change the cmobjprops7.spec? And alternately, does Anyone know if changing field names can be done in the SDK. I have a query that identifies the reports that need to be changed and what are the old names and what are the new names.
Title: Re: Can you update report definitions with SDK?
Post by: Grim on 27 Aug 2013 07:12:54 AM
http://www-01.ibm.com/support/docview.wss?uid=swg21346704

http://www-01.ibm.com/support/docview.wss?uid=swg21335769
Title: Re: Can you update report definitions with SDK?
Post by: TheBrenda on 27 Aug 2013 12:33:28 PM
Thanks for the links. Good info.

In my case the field names changed. So I am looking for how to change client ad hoc queries/reports that reference field1 to field2. It seems that when the client opens the query, they are notificed that that was a package published, and then the old field1 is stripped from the query. Not good. The client no longer know what was the old field, where was it on the query, how was it used, etc.

Is there a way in advance that we can change the query/reports references from field1 to field2?