Task 9: Creating a Derived Hierarchy using Master Data Manager
In this task, you create a derived hierarchy by using Master Data Manager. This derived hierarchy is derived from the domain-based attribute relationships between the Supplier and State entities.
Switch to the main page of Master Data Manager by clicking SQL Server 2012 Master Data Services at the top of the page.
Click System Administration in the Administrative Tasks section.
Hover the mouse over Manage on the menu bar, and click Derived Hierarchies.
.jpg "Manage Menu - Derived Hierarchies Selected")
Click Add Derived Hierarchy (+) button on the toolbar.
.jpg "Add Derived Hierarchy Button")
Type SuppliersInState for the Derived hierarchy name.
Click Save button on the toolbar.
.jpg "Save Derived Hierarchy Button")
Drag Supplier from Available Levels: SuppliersInState to Current Levels: SuppliersInState.
.jpg "Avialble Entities and Hierarchies to Current Level")
Drag State from Available Levels: SuppliersInState to Current Levels: SuppliersInState. The screen should have Current Levels as shown in the following picture.
.jpg "Current Levels and Preview of Derived Hierarchy")
In the Preview window, expand NY { New York} and you should see one supplier in that state as shown in the preceding image.
Switch to the main page of Master Data Manager by clicking SQL Server 2012 Master Data Services at the top of the page.
Click Explorer.
Hover the mouse over Hierarchies and click Derived:SuppliersInState.
.jpg "Hierarchies - Derived:SuppliersInState Menu")
Click on any state node in the tree view and you should see the suppliers in that state in the right pane.
.jpg "Derived Hierarchy in Explorer")