Deleting Imported Data in the Workbench

Use the Delete All Imported Data option to clear all imported data from your data tables for a POV period. This option enables you to clear data from the system so that you can start over when loading data.

When executed, the Delete All Imported Data option deletes the following:

• Mapping audit used for loading
• Audit information about the data load
• Process load status
• Process parameters

Note:

There is no backup to recover any deleted imported data. It is recommended that you use extreme caution before executing this process.

After the deletion, note the following:

• You cannot view any data in the Workbench for the period.
• You cannot drill down from the Oracle Enterprise Performance Management Cloud to Data Integration.

  Note:

  Drill regions are not deleted as part of the process. If you need to delete a drill region, then delete it manually.
• You cannot restore maps for the given POV period.

Note:

All setup data for example application registration, import format, and mappings are retained and not impacted by the purge process.

To delete all imported data:

1. From the Data Integration home page, click to the right of the integration, and then select Workbench.

2. From the Actions drop-down, select Delete Import Data.

   The Delete Confirmation page is displayed with the following message: "Are you sure you want to delete all the associated data for period Jan-22 from staging table?"

3. Click OK.