How to: Create a Derived Hierarchy (Master Data Services)

In Master Data Services, create a derived hierarchy when you want a level-based hierarchy that ensures that members exist at the correct level. Derived hierarchies are based on the domain-based attribute relationships that exist in a model.


If a domain-based attribute value doesn't exist for a member, the member is not included in the derived hierarchy. See How to: Require Attribute Values (Master Data Services) to require a domain-based attribute value for all members.


To perform this procedure:

To create a derived hierarchy

  1. In Master Data Manager, click System Administration.

  2. On the Model Explorer page, from the menu bar, point to Manage and click Derived Hierarchies.

  3. On the Derived Hierarchy Maintenance page, from the Model list, select a model.

  4. Click Add derived hierarchy.

  5. On the Add Derived Hierarchy page, in the Derived hierarchy name box, type a name for the hierarchy.


    Use a name that describes the levels in the hierarchy, for example Product to Subcategory to Category.

  6. Click Save derived hierarchy.

  7. On the Edit Derived Hierarchy page, in the Available Entities and Hierarchies pane, click an entity or hierarchy and drag it to the Current Levels pane.

  8. Continue dragging entities or hierarchies until your hierarchy is complete.

  9. Click Back.