4.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:

1. Navigate to Operations and Processes, select Scheduler, and then select Define Batch.
2. Create the Batch and save it.
3. Navigate to Operations and Processes, select Scheduler, and then select Define Task.
4. Select the created Batch and create a Task with Clear Dimension Members as Component.
5. Select the Dimension Name that you want to delete. You can select one or more Dimension Names.
6. 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 4-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>