Deleting Data from the Data Warehouse
You use the Data deletion task to delete data from the Data Warehouse. Two types of data are stored in the Data Warehouse: detailed log file data and summarized data. The Data Warehouse creates these types of data by keeping track of specified information as the data is being imported. If a Web log file import fails, you use the Data deletion task to delete that log file from the Data Warehouse. You can also use the Data deletion task to delete all data from the Data Warehouse.
It is important that you frequently delete obsolete log file data so that you do not experience declining performance and limited memory capacity in your Data Warehouse. If you want to maintain historic data from your Commerce Server site, you can extract the data for preservation in reports.
.gif "Ee823872.note(en-US,CS.10).gif")
Note
- Deleting data from individual Web log files requires temporary space in the Data Warehouse database. If a Data deletion task fails, free up space in the Data Warehouse database and repeat the deletion process.
After you delete data from the Data Warehouse, you must run the Report preparation task to refresh the online analytical processing (OLAP) cubes. You must select full cube processing after you delete data from the Data Warehouse.
Note
- If you delete detailed data imported from an individual Web log file, the log file data accessed by the reports in the Analysis module in Commerce Server Business Desk will remain the same. Only the Entry Path Analysis report is affected by the deletion of detailed data. If you want to delete the data the reports are based on, you must choose to delete all data imported from the Web log file.
To delete log file data
Expand Microsoft SQL Server, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.
Right-click Data Transformation Services, and then click New Package.
Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. Select the package you want to change, and then click Open.
On the Task menu, click Data deletion (Commerce Server).
In the Delete Task dialog box, do the following:
Use this To do this Description Type a description for the task. Site Name Select from the drop-down list the site that contains the log files you want to delete. Select delete type Select Web Log Imports from the drop-down list. Note- If you have two sites with different Data Warehouses, and you select All, you will only delete data from the Data Warehouse of the currently selected site. You will not delete data from both Data Warehouses.
Delete detailed data Select this option to delete the detailed data associated with the Web log files you want to delete. Select the check boxes next to the Web log files you want to delete.
Click OK.
On the Package menu, click Execute.
The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you it completed successfully.
Click OK, and then click Done.
The detailed data of the selected Web log files is deleted from the Data Warehouse. You must run the Report preparation task to organize the imported data into the designated OLAP cubes.
Note
- You can add additional Data Transformation Services (DTS) tasks to the open package, add sequencing or workflow information, and then run all the tasks in the package at one time.