Solved

Cognos running report issue

Posted on 2013-12-24
3
747 Views
Last Modified: 2013-12-28
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
Comment
Question by:amq10
  • 2
3 Comments
 
LVL 8

Expert Comment

by:SNeupane
ID: 39738058
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
 

Author Comment

by:amq10
ID: 39738877
what do you suggest to me to review.
0
 
LVL 8

Accepted Solution

by:
SNeupane earned 500 total points
ID: 39740159
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now