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

Need tips to improve the report performance

Started by umareddy0706, 28 May 2014 04:51:53 AM

Previous topic - Next topic

umareddy0706

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.

raj_aries81

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

rameshB

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

srinu_anu2007

Hi,

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

Try this one.

Thanks,