3.2.2.1.3 Clear and Back up Dimension Data
This process helps you to clear or delete the existing Dimension Data from the relevant Dimension tables using the Scheduler Services.
Before clearing the data from the Dimension tables, the service creates a back up of the table.
To clear the Dimension Data:
- Navigate to Operations and Processes, select Scheduler, and then select Define Batch.
- Create the Batch and save it.
- Navigate to Operations and Processes, select Scheduler, and then select Define Task.
- Select the created Batch and create a Task with Clear Dimension Members as Component.
- Select the Dimension Name that you want to delete. You can select one or more Dimension Names.
- From the LHS menu, navigate to Operations and Processes,
select Scheduler, and then select Execute
Batch.
The service first creates a backup of the existing Dimension table and then deletes the Dimension Member entries for the selected Dimensions.
While deleting the data from the tables, there are no validations. The back up files are suffixed with As Of Date and Current Time Stamp.
The following table gives the sample actual and backed up table names:
Table 3-5 Sample Table Names
Dimension Type | Actual Table Name | Backup Table Name |
---|---|---|
Simple Dimension | FSI_ACCRUAL_BASIS_CD | FSI_ACCRUAL_BASIS_CD_<AS_OF_DATE>_<CURRENTTIMESTAMP> |
FSI_ACCRUAL_BASIS_MLS | FSI_ACCRUAL_BASIS_MLS_<AS_OF_DATE>_<CURRENTTIMESTAMP> | |
Key Dimension | DIM_COMMON_COA_ATTR | DIM_COMMON_COA_ATTR_<AS_OF_DATE>_<CURRENTTIMESTAMP> |
DIM_COMMON_COA_B | DIM_COMMON_COA_B_<AS_OF_DATE>_<CURRENTTIMESTAMP> | |
DIM_COMMON_COA_HIER | DIM_COMMON_COA_HIER_<AS_OF_DATE>_<CURRENTTIMESTAMP> | |
DIM_COMMON_COA_TL | DIM_COMMON_COA_TL_<AS_OF_DATE>_<CURRENTTIMESTAMP> |