Skip to Content
Author's profile photo Han Hoe Lee

SuccessFactors Employee Central MDF Parent-Child relationship determination solution

It’s been awhile since I last wrote a blog. I’ve been extremely occupied with multiple projects along with the many holidays at the end of the year. Kicking off this year with a new client translates to various new requirements in need of solutions. One in particular was to basically filter a child picklist from a combination of two parent picklist value.

In this blog post, I would like to share a detailed solution using MDF to achieve the similar result without a single use of business rules.

To put it in a simple example, I would use Country, Cuisine and Food to illustrate the solution.

Configuring MDF objects

Country is already an existing MDF object. So I only need to create a new MDF for Cuisine and Food.



You must remember to define the associations to its “parents”


Manage Data

Now we need to maintain a couple of records.


For Food Type, we need to define the values based on the combination of country and cuisine.

In my example below, all cuisine types are Asian, but the countries are different.





Combining all the MDF objects

The final step is to define all the MDF created into a target. For my example, I would just be using position.

Define custom fields for each respective MDF.


Remember to include the field criteria for FoodType as per below. 



Go into manage data, either create new or edit the target MDF which we have combined all the MDF into.

When no country or cuisine is defined, food type returns 0 results


Even though we define Asian as our cuisine, food type still returns 0 results


Only after both country and cuisine has been defined we will get the returning result based off data maintain in the food type MDF.



Thank you,

Leon Lee |

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.