COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: fshahul on 08 Jul 2010 05:15:20 AM

Title: Need help to design a report to track time taken to run each report
Post by: fshahul on 08 Jul 2010 05:15:20 AM
Hi,
Anyone please provide me the steps how to design a report in Cognos to track time taken to run each report.

Thanks in advance.
Title: Re: Need help to design a report to track time taken to run each report
Post by: tupac_rd on 08 Jul 2010 07:54:52 AM
If you have audit database/tables and logging set up, I think one of the default Cognos audit reports already does what you are looking for.
Title: Re: Need help to design a report to track time taken to run each report
Post by: fshahul on 09 Jul 2010 07:03:48 AM
Hi,
Thanks for your reply but i'm not getting your point. Could you please explain me in detail?

Thanks
Title: Re: Need help to design a report to track time taken to run each report
Post by: dhavcog on 12 Jul 2010 01:09:51 AM

You have to set up Auditing in your configuration with Audit database after that you can use audit.cpf model which you can find in cognos installation folder. then publish package from framework and use to package to create your report..
Title: Re: Need help to design a report to track time taken to run each report
Post by: tupac_rd on 12 Jul 2010 08:44:33 AM
There are also some default Audit reports which are part of the samples install I think. And one of the reports if I remember correctly, already does what you are looking for.
Title: Re: Need help to design a report to track time taken to run each report
Post by: fshahul on 14 Jul 2010 07:24:40 AM
Thanks to all  :)