COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: rambabu on 31 Jul 2007 03:33:14 AM

Title: perfomance
Post by: rambabu on 31 Jul 2007 03:33:14 AM
Hi to all

how can we increase the performance in Report Net ReportStudio?

please help me out in this.

Thanks in Advance
Title: Re: perfomance
Post by: svenkat16 on 31 Jul 2007 08:01:19 AM
Hi,
you want to increase the performance of the reports?
Title: Re: perfomance
Post by: rambabu on 01 Aug 2007 12:32:28 AM
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
Title: Re: perfomance
Post by: MFGF on 01 Aug 2007 03:36:13 AM
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.
Title: Re: perfomance
Post by: raj_tumati on 05 Nov 2007 05:22:07 AM

hi,
   by applying filters and prompts to increase the performance.
Title: Re: perfomance
Post by: raj4cognos on 07 Nov 2007 11:01:00 PM



hi,
   by applying security filters to increase the performance.