Create a Derived Hierarchy (Master Data Services)
Applies To: SQL Server 2016
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.
To perform this procedure:
You must have permission to access the System Administration functional area.
You must be a model administrator. For more information, see Administrators (Master Data Services).
In Master Data Manager, click System Administration.
From the menu bar, point to Manage and click Derived Hierarchies.
On the Derived Hierarchy Maintenance page, from the Model list, select a model.
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.
Click Save derived hierarchy.
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.
Continue dragging entities or hierarchies until your hierarchy is complete.