COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: workingOnCognos on 20 Oct 2010 05:49:25 AM

Title: Restrict user for running big reports
Post by: workingOnCognos on 20 Oct 2010 05:49:25 AM
Hi,

Few beginners in my group are running report w/o filters causing large output. Is there any way I can restrict it ? say when report output size goes above 3MB. Execution should be terminated. If possible with message saying that "large report..contact admin"

Thanks
Title: Re: Restrict user for running big reports
Post by: rockytopmark on 21 Oct 2010 12:36:37 PM
There are Governor settings available in the model or on individual RS queries that allow you to set:
1. Maximum Rows Retrieved
2. Maximum Tables
3. Maximum Execution Time

... but nothing for "size" as I am not sure how Cognos would quantify the size of a request's ultimate result.