Data loading in Cognos excel slowness

[PRIT AMRIT]

Dear friends,

Running the report in Cognos Excel ( 2007) – I really would like to know what methodology Cognos follows when rendering the Report in Excel/PDF format. My understanding is, the Report SQL is sent to underlying DB ( in my case Oracle), then retrieve all the records and stores in the Cognos Local Server and then translate to IE for saving in Excel/PDF.  Please correct me if I am wrong.

Because my report are running in 5-10 mins rendering in HTML. I understand it fetches row basis, but still I can page down and quickly see the data. But the same report when I run in Excel ( File size 60 KB), it takes around 30mins.

If you have already experienced the same and could overcome with some tricks, pls do share?

Thanks a lot!

Regards,
Prit

[ramprasad]

I'm also facing Same issue