Dropping DTA Tables

The Drop DTA table(s) maintenance task allows to remove pre-mined data from the MS database including tables for the reports matching the task criteria.

To drop DTA tables

1. On the Navigation Tree, click Report Warehouse, then click Maintenance and select Maintenance Tasks.

2. Click on the Maintenance Tasks page. The Maintenance Task page appears.

3. Configure a maintenance task, making sure to select the Drop DTA table(s) option from the Task Type drop-down list.

4. Click Save.

5. On the Navigation Tree, click Report Warehouse, then click Maintenance and select Maintenance Processes.

6. Click on the Maintenance Processes page. The Maintenance Process page appears.

7. Configure a maintenance process, making sure to assign the maintenance task you just created to it.

8. Schedule the process to run, or run it manually by clicking Run Now on the Maintenance Process page.

 When the process is executed, the maintenance task runs and all premined data including tables is removed from the database.