Solved

Report Output Versions - Space Concern

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now