Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Report Output Versions - Space Concern

Posted on 2008-10-09
1
Medium Priority
?
1,060 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 2000 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

Industry Leaders: 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

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Loops Section Overview

971 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