Timing report execution
We often want to record the exact time taken by a report to execute. This recipe will show you a technique that is tried and tested and can be used repeatedly to examine the performance of a report at different loads and volumes on the data source.
Getting ready
Take any report whose execution time is to be recorded. The steps for this recipe are to be carried out in Cognos Connection Portal, not Cognos Report Studio.
How to do it...
In this recipe, we will see how to get the time taken by the report to be executed by getting the start time and the completion time for the report from Cognos Connection Portal.
Go to IBM Cognos Connection Portal and locate the report.
Click on the Create Report View button and create a report view of this report in the desired location.
Open the Properties pane of the report view by clicking on the Set Properties button.
Go to the Report View tab. Uncheck the Prompt for values option.
Click on the Set link for Prompt values. This will bring...
