Setting execution time out
Some reports are capable of firing quite resource consuming queries on the data source. This can cause a bottleneck on the database and hence a problem for other users and jobs. This recipe will show you how to automatically get the report query killed if it takes longer than a certain time limit.
Getting ready
Create a simple list report based on GO Data Warehouse (Query) package. Pull Product line, Product type, and Product name as columns.
How to do it...
- Open the report in Cognos Report Studio.
- Go to Query Explorer and select Query1.
- From Properties pane, open Maximum Execution Time property.
- Set it to a low number. For testing, we will set it to 1.
That means we are setting the maximum execution time for the query to one ...
Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.