Solved

Report Output Versions - Space Concern

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying 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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

756 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