2236017 - Mass Deletion of MDF Data via Import

SAP Knowledge Base Article - Public

2236017 - Mass Deletion of MDF Data via Import

Symptom

  • How to perform mass deletion of MDF data via import?
  • How to delete top level MDF objects via import?
  • How to delete composite associations via import?
  • How to delete Position object data via import?

Environment

  • SuccessFactors Cloud HCM: MDF
  • SuccessFactors Cloud HCM: Import and Export Data

Resolution

With the 1705 release, customers can now perform mass deletion of MDF data via import. Mass deletion of the MDF data can be performed both on Top Level objects with or without associations or perform import to delete only the composite associations of a certain parent object.

Operators available for deleting the data:

  • Delete is used to delete root object or parent object data
  • Delimit and Clear can be used only associations. Delimit is for deleting a specific record of a child object from a parent object whereas Clear is used for deleting all the records of a child object from the parent in forward propagation.

Follow the steps below to delete MDF data of the required MDF Objects:

  1. Login to your SuccessFactors instance
  2. Navigate to Admin Center --> Import and Export Data
  3. Export Data of the required root/top level object MDF object as shown in the screenshot below

         2236017_5.PNG

        4. Open the downloaded file with the data and enter the value DELETE in the Operator column as shown in the screenshot below for the instances/data of the object you want to delete

         2236017_4.PNG

        5. Now import the file by navigating back to Admin Center --> Import and Export Data and import the file. Once the import is completed, you will notice that the different effective dated records of data for the child will be deleted for the MDF Object.

NOTE: Operator DELETE is not supported for Full Purge import

 For deleting the data for the child objects, follow the steps below

  1. Export Data of the required child(associated) MDF object as shown in the screenshot below

        2236017_1.PNG

       4. Open the downloaded file with the data and enter the value DELIMIT in the Operator column as shown in the screenshot below

        2236017_2.PNG

      5. Now import the file by navigating back to Admin Center --> Import and Export Data and import the file. Make sure to select the child MDF Object for which you are performing the import to delete the required records of MDF data (refer the screenshot below). Once the import is completed, you will notice that the different effective dated records of data for the child will be deleted for the MDF Object.

        2236017_3.PNG

***Note**** - If you what all data purged, export the parent data and use the operator DELETE and then import the data. This will purge the child data also ****Note****

Keywords

MDF: Metadata Framework, Purge MDF data, Full purge via import / export data, DELIMIT, DELETE , KBA , mdf, delimiter , LOD-SF-FWK-MDF , MDF Framework , LOD-SF-EC-MDF , MDF & EC2MDF Migration , Problem

Product

SAP SuccessFactors HCM Core all versions