Create a Derived Hierarchy (Master Data Services)

Applies to: SQL Server - Windows only Azure SQL Managed Instance

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

  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 Drop Parent Here in Current Levels pane.

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

  9. Click Back.

See Also

Derived Hierarchies (Master Data Services)
Derived Hierarchies with Explicit Caps (Master Data Services)
Domain-Based Attributes (Master Data Services)