Purge All Imported Data

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

When executed, the Purge All Imported Data 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 purged data. It is recommended that you use extreme caution before executing this process.

After the purge, note the following:

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

  Note:

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

Note:

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

To purge all imported data:

1. On the Workflow tab, under System Maintenance Tasks, select Purge All Imported Data.
2. From the POV bar, and then Location, select the location associated with the data to be purged.
3. Click Execute.

   

4. From Execute Script, and then in Confirm Delete All Imported Data, select Y (yes) to launch a confirmation message before executing a purge.

   Otherwise, enter N (No).

5. In Reason, specify the reason for executing the purge.

   The reason is shown on the Process Details log.

6. Click OK.

   The message: Custom script executed initiated with Process ID: XXX is displayed (where XXX is the process id number generated for job). You can access the log from the Process Details page.

7. Optional: Click Schedule to schedule the job.

   For information on scheduling jobs, see Scheduling Jobs.