If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Run Time for reports with page sets

Started by farmcock, 21 Aug 2014 03:50:16 PM

Previous topic - Next topic

farmcock

I was aware that Page sets tend to slow down the report and increase run time. I have a report that not only has our usual page sets in it for grouping & Sorting on Region & Company but I had to use Master-Detail relationship between Query 1 (Master) and 5 other queries.

the report is running so long now that our DB admin had to cancel it earlier today. Can anyone give me some suggestions on this? Do the Master-Detail relationships tend to slow the report also in addition to the page sets?