Hello
I work with Cognos 10.1 and I would like to limit the number of rows returns by my report.
For example, my request normally has to return 1 000 000 of the lines, but I want to display that 10000.
I tried in Framework manager to modify the value of the parameter "Maximum number of retrieved rows" in "Edit Governors" to put that value to 10000.
But when I create a report with report studio with my previous package I have an error message after running the report: " RQP-DEF-0110 " (The number of rows retrieved for the to use(wear out) who has the identity ' {
Everyone, Authors, Query Users, Consumers, Metrics Authors)
Does, everyone has already met this problem?
For testing purposes it would make more sense to add appropriate filter(s) to the report. I struggle to understand the need to fetch 1.000.000 rows though. The limit is primarily a safeguard, not for limiting data to speed up development
As rightly said by blom, I dont see a point in pulling 10000 rows. However, you can do this by creating running count for the rows and then add a filter to the report on that running count
Agreed, but what is the point in retrieving said 10.000 rows (at random? ) Adding a running count simply adds a whole lot of workload on the server (as these are not computed in the query) With 10.000 rows fetched you can have partial results for the query if you use grouping levels. Using filters yields complete sets in any case