where we can see ther report execution Time.

[Mahendra]

Hi Gurus,


                One of the report is taking so long time to generate,where can we see the Execution time in cognos.


Regards
Mahendra

[NaviGator]

Hello Mahendra,

You will need to "Run the report with Option" and chose to save the report. Then you can see the execution time - start and end time - from the report Run History  OR in the Administration Page you can see your report in Current or Past activities.

But remember, for both options you will need to Save the report.

Hope this could help.

[ducthcogtechie]

it is also written to the audit database, when you schedule it.
Unfortunately it will only write start/complete time, and not the actual fetchtime (waiting for db server) versus calculation time (local processing), which is probably what you want to know.

Use the auditing logic to find out if you're runtime is having specific issues during the day (just schedule it to ru nevery 30 min), and run the report directly on the server, and open up taskmanager and time betwene starting the report, and for the bibus proces to start calculating.
That should give you a hint if you're waiting for fetchtime, or if the report requires a lot of time for local processing.