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

[squish88]

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

[AussiePete2011]

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

[squish88]

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!!