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
I'm also facing Same issue