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.
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.
Go to 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 of the report view by clicking 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 the prompt page up.
Select the prompt values and save them. Click the OK button to come back to the list of reports and report views.
-
Now click on the Run with options button
and choose following...