Print Page - Need tips to improve the report performance

Title: Need tips to improve the report performance
Post by: umareddy0706 on 28 May 2014 04:51:53 AM

Hello Everyone,

I have a report with 60 prompts( most of them are optional) and in the report page, I have list report with 120 columns.

Issue: Report is running very slowly. It is taking 20-25 minutes for execution. My client wanted to improve the performance.

Please advise me to improve the performance of the report.

Regards
Mahesh.

Title: Re: Need tips to improve the report performance
Post by: raj_aries81 on 28 May 2014 05:56:11 AM

Hi Mahesh,

Pl include more details. Did you check things like volume of data...query execution time on DB etc. Instead of adding all the prompts, I think it would be better to adopt a phased approach by adding 8-10 prompts each time and then running the report to check the report performance.

Regards
Raj

Title: Re: Need tips to improve the report performance
Post by: rameshB on 28 May 2014 06:07:11 AM

hello Mahesh,
1. identify the fields/columns that are taking long time at time for execution of report.
2. Ask database team create index on that particular column name.
3.check the execution time from the database end before running the report in report studio.

regards,
Ramesh

Title: Re: Need tips to improve the report performance
Post by: srinu_anu2007 on 28 May 2014 07:10:09 AM

Hi,

Try to use Processing Property(goto Queries->goto properties->Processing->select Database Property

Try this one.

Thanks,

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: umareddy0706 on 28 May 2014 04:51:53 AM