Create an Explicit Hierarchy (Master Data Services)
Applies to: 
SQL Server - Windows only
Azure SQL Managed Instance
In Master Data Services, create an explicit hierarchy when you need a ragged hierarchy in which members can exist at any level. Explicit hierarchies contain members from a single entity.
After you create an explicit hierarchy, you can add members to it in the Explorer functional area.
Prerequisites
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).
The entity must be enabled for explicit hierarchies and collections.
To create an explicit hierarchy
In Master Data Manager, click System Administration.
On the Manage Model page, select a model from the grid and then click Entities.
On the Manage Entity page, from the grid, select the row for the entity that you want to create an explicit hierarchy for.
Click Explicit Hierarchies.
On the Manage Explicit Hierarchy page, click Add.
In the Name box, type a name for the hierarchy.
Optionally, clear the Mandatory hierarchy check box to create the hierarchy as a non-mandatory hierarchy. For more information about hierarchy types, see Explicit Hierarchies (Master Data Services).
Click Save.
Grid Columns
For each explicit hierarchy that you create, a row with seven columns is added to the grid. The following is a description of the columns.
| Name | Description |
|---|---|
| Status | The entity status. When you click Save the following image is displayed that indicates that the entity is updating. If there are errors when creating or editing an entity, the following image is displayed.  If the status is OK, then the following image is displayed.  |
| Name | The explicit hierarchy name. |
| Is Mandatory | Specifies whether the explicit hierarchy is mandatory. |
| Created By | The username of the user who created the explicit hierarchy. |
| Created On | The date and time when the explicit hierarchy was created. |
| Updated By | The username of the user who last updated the explicit hierarchy. |
| Updated On | The date and time when the explicit hierarchy was last updated. |
Next Steps
See Also
Explicit Hierarchies (Master Data Services)
Derived Hierarchies with Explicit Caps (Master Data Services)
Change an Explicit Hierarchy Name (Master Data Services)