COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Shailaja0520 on 18 Sep 2012 02:31:01 AM

Title: Identify
Post by: Shailaja0520 on 18 Sep 2012 02:31:01 AM
How to
Title: Re: Identify the peak time cognos Audit Package
Post by: RKMI on 18 Sep 2012 11:16:44 AM
Hi,

You need to create a custom audit report where you can see how many reports are being exectued at a given hour for the week and then you do some conditional formatting to figure out the range within the hours.

Ex:
               Time of day
         8 9 10 11 12 1 2 3 4 5 6 7
Day1 10 50 60  10 10 50 50 60  10
Day2 10 50 60  10 10 50 50 60  10
Day3 10 50 60  10 10 50 50 60  10
Day4 10 50 60  10 10 50 50 60  10

Thanks,
RK