| title | Task 9: Creating a Derived Hierarchy using Master Data Manager | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 12/29/2017 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.technology | data-quality-services |
| ms.topic | conceptual |
| ms.assetid | 3bd2ec05-933f-4947-b1fe-c9226961eb7d |
| author | leolimsft |
| ms.author | lle |
| manager | craigg |
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.
-
Click Add Derived Hierarchy (+) button on the toolbar.
-
Type SuppliersInState for the Derived hierarchy name.
-
Click Save button on the toolbar.
-
Drag Supplier from Available Levels: SuppliersInState to Current Levels: SuppliersInState.
-
Drag State from Available Levels: SuppliersInState to Current Levels: SuppliersInState. The screen should have Current Levels as shown in the following picture.
-
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.
-
Click on any state node in the tree view and you should see the suppliers in that state in the right pane.
