Print Page - Active Report Row Limit? (RQP-DEF-0110 Error) -- SOLVED

Title: Active Report Row Limit? (RQP-DEF-0110 Error) -- SOLVED
Post by: squish88 on 15 Aug 2011 12:08:41 PM

Hey all,

So my first attempt to make an active report went well enough, but now that I'm trying to expand the report to bring in more data, I'm getting:

The number of rows retrieved for the user who has the identity '{Everyone, System Administrators, All Authenticated Users, Consumers, Analysis Users, BI Administrators, Cognos System Adminsistrator}' exceeds the limit of 5000.

Any idea how/where to jack up that limit to something realistic??

Thanks in advance,
Jim

Title: Re: Active Report Row Limit? (RQP-DEF-0110 Error)
Post by: AussiePete2011 on 15 Aug 2011 05:02:59 PM

Hi Jim

"https://www-304.ibm.com/support/docview.wss?uid=swg21346727"
"https://www-304.ibm.com/support/docview.wss?uid=swg21340548"
"https://www-304.ibm.com/support/docview.wss?uid=swg21346511"

thats to begin with
Cheers
Peter

Title: Re: Active Report Row Limit? (RQP-DEF-0110 Error) -- SOLVED
Post by: squish88 on 16 Aug 2011 08:35:56 AM

Turns out it's even easier than all that... I missed entirely that there's an "Active Report Properties" option under the File menu... (found it about a 1/2 hour after posting this issue). I just changed the "Maximum Query Rows" setting and was off and running. Total PEBKAC..... :)

Thank you for the links though!!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: squish88 on 15 Aug 2011 12:08:41 PM