Setting maximum rows limit
This is similar to the previous recipe. Instead of setting any limit for query execution time, here we will set a restriction on the number of rows returned by the query.
Getting ready
We will use the report created in the previous recipe for this.
How to do it...
Open the report in Report Studio.
Go to Query Explorer and select the report query.
From the Properties pane, open Maximum Rows Retrieved property.
For testing purposes, set it to 50.
Run the report in HTML format.
Browse the report page by page. As soon as you hit the record count of 50 (usually on third page), you will receive an error message saying that the query has reached the maximum row limit.
Go back to Cognos Report Studio and change the limit to required row limit. For example, 2000.
How it works...
This option serves same requirement as last recipe. When you want to ensure that the data source is not burdened by heavy queries, you should set such limits.
The maximum rows limit can also be set at package...
