Solved

Report Output Versions - Space Concern

Posted on 2008-10-09
1
1,049 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
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to increase the row limit in Jasper Server.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

861 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