Cognos running report issue

Hi,

I developed I report in Cognos when I run the report in as HTML or PDF format it takes long time over 5 minutes, and when I run it as Excel it gives error meg ' report does not respond' after 10 minutes waiting.

note that expected data is not huge, it is only one PDF page, but my target format is Excel.

What is the issue.

Regards,
amq10Asked:
Who is Participating?
 
SNeupaneCommented:
Take the SQL query from the report and run in Toad or SQL studio and see how long it takes to return data.
0
 
SNeupaneCommented:
It doesn't matter how big is the output.
What matters is how much data is the report fetching to produce that one page output.
Looks like your query is huge.
Take the SQL query from the report and run in Toad or SQL studio and see how long it takes to return data.
On top of that, Cognos needs to do additional formatting, calculations, display etc...
0
 
amq10Author Commented:
what do you suggest to me to review.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.