RePORT Performance down after Rows per page set as 100000

[tarunkrdas2013]

Hi ,mine is crosstab tab report nested under list report (its a requirement as we are changing from cube to DMR).Output is Weekly sales shown per Fiscal week and there is a section at Fiscal week ,hence i want all week lke fiscal week 1 fiscal week 2,fiscal week 3, fiscal week 4 data in one page ,current report with cube package has "Rows per page " property set as 100000 but when i put the same setting with DMR package i.e. i put "Rows per page " property set as 100000 ..performance of report goes slow like fiscal week 1 fiscal week 2,fiscal week 3, fiscal week 4 data comes at 1minute 30 seconds .

When i remove the setting "Rows per page " to 0 ,i see good perfromace i.e. output comes at 14 seconds,can anyone suggest what can i do achieve good performance

[Francis aka khayman]

when you set rows per page to 100000, all rows get retrieved which i will guest take significant amount of time before your output is displayed.

when you remove rows per page value, the report retrieves the minimum number of rows and display your output. the rest of the rows get retrieved when you click "Next page" Or something like that, hence you get the impression that the performance is "better".

[MFGF]

when you set rows per page to 100000, all rows get retrieved which i will guest take significant amount of time before your output is displayed.

when you remove rows per page value, the report retrieves the minimum number of rows and display your output. the rest of the rows get retrieved when you click "Next page" Or something like that, hence you get the impression that the performance is "better".

Nobody seems to be mentioning the elephant in the corner? We can all see it's there, though. Ok - I'm going to. :)

What possible business use would a person gain from a 100,000 line report? Seriously? That's not a report, it's a data dump. Who is ever going to read it? It's longer than a novel, and not remotely as interesting. Why wouldn't you focus on what's important rather than just spewing out all the data on the page?

Ok - now we can all relax - the elephant has been identified :)

MF.

[Francis aka khayman]

after years of evaluating user requirements and user requests for Cognos reports, seeing an elephant in the corner would be the least weird thing

[Lynn]

after years of evaluating user requirements and user requests for Cognos reports, seeing an elephant in the corner would be the least weird thing

That is so true and very funny. I did an Applaud since there isn't a Like feature on the forum

;D

[tarunkrdas2013]

I thank everybody for your to the point analysis ,i will try to give explanation to  business users to have a Fiscal week 1 on page and Fiscal week 2 on next page so as to have better analysis and not big data dump