Create an Explicit Hierarchy (Master Data Services)

 

Updated: April 1, 2016

Applies To: SQL Server 2016

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.

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

  1. In Master Data Manager, click System Administration.

  2. On the Manage Model page, select a model from the grid and then click Entities.

  3. On the Manage Entity page, from the grid, select the row for the entity that you want to create an explicit hierarchy for.

  4. Click Explicit Hierarchies.

  5. On the Manage Explicit Hierarchy page, click Add.

  6. In the Name box, type a name for the hierarchy.

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

  8. Click Save.

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.

NameDescription
StatusThe entity status. When you click Save the following image is displayed that indicates that the entity is updating.

 Icon for updating status

If there are errors when creating or editing an entity, the following image is displayed.

 Icon for error status

If the status is OK, then the following image is displayed.

 Icon for OK status
NameThe explicit hierarchy name.
Is MandatorySpecifies whether the explicit hierarchy is mandatory.
Created ByThe username of the user who created the explicit hierarchy.
Created OnThe date and time when the explicit hierarchy was created.
Updated ByThe username of the user who last updated the explicit hierarchy.
Updated OnThe date and time when the explicit hierarchy was last updated.

Explicit Hierarchies (Master Data Services)
Derived Hierarchies with Explicit Caps (Master Data Services)
Change an Explicit Hierarchy Name (Master Data Services)

Community Additions

ADD
Show: