On the List/Chart look for an option in the Properties pane under the Data group called “share Result Set” and set it to yes. If you have at least one chart and one list that use the same properties and grouping structure, you can share the result set. Is there something in the way that Cognos builds up large PDFs which causes it to use so much memp area? Is there any parameters I can modify to vary the amount of tmp space Cognos is likely to use etc. But I’m more concerned about the 200GB of tempspace being used to generate a 3,000 page report which just seems very wrong. I’ve tried modifying the cache settings in the queries, but to no avail. Therefore to render 3,000 pages is requiring 15,001 queries. Ive also noticed that the page 2 graphs are not being rendered from a single query, but each graph is running a query. CGSErrorAssert:0:Fatal: CGS_ASSERT(writeOk, “”Write to cgs temporary file failed, check that disk is not full.””) ”” “”RSV-SRV-0040 An application error has occurred. It runs for 12 hours, then fails when the server’s disk fills producing the following error… The report however will not render to PDF. It all works fine in HTML, and the page transitions are quick, only a few seconds each, So I was hoping that report performance would be around 30minutes when rendering to PDF, as the page count had doubled, and I now had a master detail relationship, which meant that the number of queries hitting the database had risen from 1 to 3,001 essentially (all really low cost). To do this I have a second page, within the original pageset containing, 5 graphs all from a new detail query which returns all of the metrics for the 5 graphs, filtered by a master detail relationship between the original query,( driving the pageset and page 1), and the new query (providing the detail graphs in page 2).
12 HOURS BY 12 WEEKS PDF TOOLBOX SERIES
However, I need to add a second page containing 5 small graphs, one or 2 series per graph, with 12 months history for the same 3000 dealers. The existing report uses 1 query which drives a pageset, containing 1 page, driven from the same query I’m having an existing report which generates 3000 pages of pdf, one per customer, containing a single month of data, 30 or so metrics, in a nice tabulated format in approx 10 minutes, performance which I am more than happy with given the power of our servers.
0 kommentar(er)
