Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to improve performance

Status
Not open for further replies.

riskassure

Programmer
May 6, 2005
33
US
Hello, I developed a report using Report Studio in Cognos 8.4. Basically, I have one massive master query that generates all the data I need for the report. There are about 30 or so pages, and each page contains about one or two tables or charts based on this master query (enclosed is a screenshot of part of query explorer). When I want to just view the data, I run the View Tabular Data, and the resulting table usually returns after a few minutes (no more than 5 minutes). However, when I run the report in PDF, sometimes it could take over an hour to run. I am under the impression that when the report is run, Cognos first runs the master query, saves the result locally or somewhere, then use the results to produce tables and charts on each of the pages. Perhaps that's not the case? Maybe Cognos re-runs the master query each time whenever a table or a chart calls for it?? Does anyone know why it's taking a long time to run? Any idea on how to improve report running performance?

Thanks in advance!

~~CW~~
 
 http://files.engineering.com/getfile.aspx?folder=e9a9a5b2-b89d-4b92-bee6-d94bb9cb17a6&file=cognos.bmp
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top