how to see 25000 records per page

[inu]

HI
TO display 25000 rows per page. what should I do. I told a cognos specialist about rows per page property solves this problem, he refused to accept the reply. Even I practically used the rows per page , got success. However I want to confirm from your side .
Can you justify it.

Thanks
Inam

[MFGF]

...he refused to accept the reply...

Did you demonstrate the solution to him? How can he refuse to accept something you are proving before his own eyes?

MF.

[bdbits]

I'm really curious as to why you would want to display 25000 rows per page. It seems to me that would be a bit much for a user to look through.

[navissar]

How to do what now?
I think I know why your customer rejected the "rows per page" solution - it would break down an Excel export to a new tab each 25K rows.
But bdbits had it right: I seldom challenge a customer's request (I swear I once inserted a GIF of a moving truck to a customer's dashboard), but this is one I would fight tooth and nail. It's not just "Old BI", it's not BI.
No one in their right mind would sift through 25K records in one HTML page. No business analyst I ever met would dream of sifting through 25K records, period.
When you pull that kind of data up, you can be sure that the user will dump it in Excel, and then apply filtering, calculations, aggregations and so on. So basically, your customer bought a BI product that costs around a thousand dollars for a basic license, just to dump SQLs into Excel. There are cheaper ways to do this, I guarantee. Your customer has the world's leading BI platform - let him use it to make 25K records into the 300 that matter! We have all sorts of tools - bubble up metrics, drill through on aggregates, charts, groupings, threshold, dynamic sorting and filtering and so on - we can do everything the user will end up spending half a day doing in Excel straight off the bat, and allow the user to achieve better insights in minutes flat from the same data. It would perform better, it would yield better results and better ROI, it would make the end analysis available for other functions in the organization without keeping, tracking and emailing massive Excel files - it would be better, plain and simple.

So, to summarize, if a customer asks me to display 25K rows in a page, my first answer won't be "Oh, you could say the number of rows property", it would be "Are you for real?!"

[Raghuvir]

Does increasing the value for rows per page hamper the performance of the report ?

Regards

[MFGF]

Does increasing the value for rows per page hamper the performance of the report ?

Regards

Yes - if rendering as HTML interactively. Normally in this situation, the report would need to retrieve and render only the 50 or so rows for the first page. If you increase the rows per page, there is more data to retrieve and much more to render in one hit.

MF.

[Raghuvir]

Yes - if rendering as HTML interactively. Normally in this situation, the report would need to retrieve and render only the 50 or so rows for the first page. If you increase the rows per page, there is more data to retrieve and much more to render in one hit.

MF.

Thanks MFGF for the guidance. Any idea what is the maximum we can enter in rows per page ?

Regards

[MFGF]

Thanks MFGF for the guidance. Any idea what is the maximum we can enter in rows per page ?

Regards

Hi,

No, but (to echo the sentiments of Bob and Nimrod above) why would you want to make it a big number? Who is going to use a report consisting of thousands of rows? Why not filter and present only what the user is interested in seeing?

MF.

[Raghuvir]

was just curious to know the max number that we can enter. would always use filters to show specific data rather than just creating an dump file.

Thanks MFGF

Regards

[Robl]

You used to be able to enter 0 in "rows per page" and it would return all rows.
It doesn't work anymore.

If the question is;
How do you return 25000 rows? then your answer was correct, use the rows per page option.

If the question is;
There's been a request to return 25000 rows, discuss.
Well, then there's a longer answer.