COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchow on 14 Sep 2015 05:39:50 AM

Title: Report Performance issue while exporting or scheduling
Post by: kvchow on 14 Sep 2015 05:39:50 AM
Hi,

I am facing strange issue,when i click on the report to ran after giving the inputs it is running in less than 3 minutes,when i try to export the same output it is keep on running and timed out,the same is happen when scheduled the same report to my email

I have only 1500 records ,version 10.1 and db2 db

Thanks
kvchow
Title: Re: Report Performance issue while exporting or scheduling
Post by: MFGF on 14 Sep 2015 06:16:47 AM
Quote from: kvchow on 14 Sep 2015 05:39:50 AM
Hi,

I am facing strange issue,when i click on the report to ran after giving the inputs it is running in less than 3 minutes,when i try to export the same output it is keep on running and timed out,the same is happen when scheduled the same report to my email

I have only 1500 records ,version 10.1 and db2 db

Thanks
kvchow

Hi,

Take a look at Reporting FAQ #2 in this post:

http://www.cognoise.com/index.php/topic,27563.0.html

This explains why you see results much more quickly when rendering reports interactively in HTML vs other formats/scheduled runs.

MF.