Maintaining and Storing Reports
Discusses maintaining reports in the On Demand database.
By default, Webtrends Analytics copies the top-most elements from the analysis tables to the report database (also called the On Demand Database). You can increase the number of elements Webtrends Analytics copies to the report database, but as you increase this number the performance of the On Demand Database decreases. In general, we recommend limiting the On Demand Database for best performance.
Webtrends also allows you to control the number of reports kept over a period of time. You could, for example:
- Delete all daily reports that are more than 90 days old.
- Keep weekly reports only over the last 52 weeks.
- Keep only eight quarterly reports and two yearly reports.
By limiting the number of reports to keep in the On Demand Database, you can reduce the storage space required.
There is a trade-off between keeping large amounts of data and maintaining a robust database that generates reports efficiently. Some organizations may find great value in keeping a large volume of historical data, no matter what the cost in performance. Other organizations may find little value in maintaining daily reports from the previous year. This decision depends on your organization’s needs and resources. To limit the data stored in the On Demand database:
- In the left pane, click Administration > Application Setting > System Management > Retention > Report .