COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: laxmanrao83 on 04 Nov 2009 11:04:12 PM

Title: Report Performence
Post by: laxmanrao83 on 04 Nov 2009 11:04:12 PM
Hi Friends ,

How to improve the report performence.

Regards,
Laxman
Title: Re: Report Performence
Post by: NaviGator on 05 Nov 2009 01:39:17 AM
Hello Laxman,

This is really a hard question that doesn't have a straight answer. It depends on your report itself.

As a golden Rule, Try to simplify your report as much as you can. If there is a chance to build the components in your report in more than one report do it.

It depends also on your model. A well designed model will help you to improve the report performance. Try to do most of the processing in the database side not in Cognos side. You may need also to talk to your database Administrator to make sure that the tables you are using are indexed.

These are very quick notes that are in my head right now. I will try to come up with more hints.

Thanks ..