Author Topic: Maximum Records Query Studio Can Hold  (Read 2697 times)

Offline knip

  • Full Member
  • ***
  • Join Date: May 2011
  • Posts: 47
  • Forum Citizenship: +0/-2
Maximum Records Query Studio Can Hold
« on: 27 Sep 2012 09:49:02 am »
Hi Experts,
                 can you please let me know how many records can query studio handle?

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,610
  • Forum Citizenship: +335/-1
Re: Maximum Records Query Studio Can Hold
« Reply #1 on: 01 Oct 2012 12:22:13 pm »
A lot.

Offline tjohnson3050

  • IBM Certified Solution Expert - Cognos BI
  • Statesman
  • ******
  • Join Date: Dec 2011
  • Posts: 370
  • Forum Citizenship: +63/-0
  • The only dumb question is the one never asked.
    • Linked In Profile
Re: Maximum Records Query Studio Can Hold
« Reply #2 on: 01 Oct 2012 01:00:36 pm »
Love it Lynn  ;D

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,233
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Maximum Records Query Studio Can Hold
« Reply #3 on: 04 Oct 2012 12:35:34 pm »
My answer would be... as many as there are within your report :)

Seriously, how many rows of data do you want your report to return? I would suggest that anything more than a hundred is not going to be useful. How many users will sit scrolling through page after page after page of data? They will quickly give up and look elsewhere for their information.

Can you tell us what you're trying to do?

MF.
Meep!

 


       
Twittear