Purge Report Table Data

Use this screen to purge various outdated report tables that have grown over time because of the accumulation of report table rows that have been created to run different Costpoint reports.

Many reports print from report tables that are created in a separate process. These report tables must be created each time a report is printed for a different fiscal year, period, and subperiod because new data will be used. Over a period, the report tables accumulate many rows of data, and the processing time slows. This process clears data and free disk storage resulting in faster processing time.

You can use this utility to purge all or some of the report tables. You can also select the purging age of the reports. This clears any report data more than a user-specified number of days old.

Include this utility as part of your database administration maintenance procedures.

After entering your preferences, click process.gif to start purging the tables based on the parameters you selected.