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

perfomance

Started by rambabu, 31 Jul 2007 03:33:14 AM

Previous topic - Next topic

rambabu

Hi to all

how can we increase the performance in Report Net ReportStudio?

please help me out in this.

Thanks in Advance

svenkat16

Hi,
you want to increase the performance of the reports?

rambabu

thanks for replay

yes, i want to increase the performance of the reports.

i know that by applying filters and prompts we can increase the performance.

is there any another ways to increase the performance?

thanks in advance

MFGF

Hi,

Just another couple of tips:

Keep the report (and the query) as lean as possible - ie don't bring in items that are not required.
Try to keep the number of items you group and/or sort on to a minimum - ie use 'level span' where appropriate rather than grouping on a second column having a 1:1 relationship with an existing grouped column.
Try to keep the number of query calculations to a minimum, and particularly try to avoid using functions/summaries that you know may give poor performance.

Regards,

MF.
Meep!

raj_tumati


hi,
   by applying filters and prompts to increase the performance.

raj4cognos




hi,
   by applying security filters to increase the performance.