Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: gats1527 on 13 Dec 2011 10:51:23 AM

Title: Log of all data changes from contributor web model
Post by: gats1527 on 13 Dec 2011 10:51:23 AM
We would like to see a log of all the changes made in a contributor web model.  We are running version 8.4
Title: Re: Log of all data changes from contributor web model
Post by: ericlfg on 13 Dec 2011 10:58:14 AM
Hi Gats,

Chapter 16 of the Contributor administration guide details the various commentary options, including user audit annotations.  Please see pg. 74 to see how to enable this.

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/8.4.0/contrib_admin.pdf

Cheers,
Title: Re: Log of all data changes from contributor web model
Post by: gats1527 on 15 Dec 2011 02:00:39 PM
Thanks Eric.  We currently had our histroy tracking set to Action time stamps, but i think setting it to full debug will assist us. 
Title: Re: Log of all data changes from contributor web model
Post by: gats1527 on 15 Dec 2011 02:14:31 PM
One other question about this setting.  How can i go an look at the logs of data?  DO i have to go onto the server?
Title: Re: Log of all data changes from contributor web model
Post by: ericlfg on 15 Dec 2011 09:33:58 PM
You can use the commentary browser in any node and see the data on the pages associated with that node.  The other option is to use the publish feature and select to publish annotations and you will get a table in the publish database prefixed with an_<cube_name>.  This should, from what I recall, be all commentary both user audit data and user input values.
Text only | Text with Images