Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 886
  • Last Modified:

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,
0
amq10
Asked:
amq10
  • 2
1 Solution
 
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
 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now