Solved

Report Output Versions - Space Concern

Posted on 2008-10-09
1
1,052 Views
Last Modified: 2010-04-29
Hello,

Can someone tell me how Report Output Versions are stored in Cognos 8.3?  Does it store these files somewhere on the app server or in the content store?  It doesn't seem to access the database everytime one is opened.

The reason I'm asking is that many of the reports ran are very large and we're worried about space.  

My second question, is there a way to run a job that purges report outputs?  For example, looks for any report output older than 90 days and deletes it.

Thanks!
0
Comment
Question by:dakinegeek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
ID: 22688746
When you run a report and "save" it, the cognos report engine retrieves the data required for the report, and sends it to the Content Manager to be stored within the content store.  When you go to "view" this saved output, the data is then retrieved from the content store and sent to the presentation service, which generates the formatted output that is then sent to the user.  ALong hte way, it'll get stored in temporary files in the "Temp" directory.

Files in the temp directory are (normally) deleted once they are no longer needed (which can be as long as 15 minutes after the last time the report is accessed).

For you second question, you can control the number of "Versions" that Cognos 8 will store as a property of the report.  you can choose to restrict either the number of versions or the age of versions as required.  

FInally, there is a task you can create in the "Content Adminstration" screen called "Consistency Check".  This job will go through the content store and remove report outputs that are no longer needed (either because the user who created no longer exists, or becuase it is older then the settings specified above).
0

Featured Post

Independent Software Vendors: 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!

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.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

623 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