create-an-explicit-hierarchy-master-data-services.md

title	Create an Explicit Hierarchy (Master Data Services) | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	master-data-services
ms.topic	conceptual
helpviewer_keywords	creating explicit hierarchies [Master Data Services] explicit hierarchies, creating
ms.assetid	ba768393-6990-4eda-8cb0-d58cb3cfc2e2
author	lrtoyou1223
ms.author	lle
manager	craigg

Create an Explicit Hierarchy (Master Data Services)

In [!INCLUDEssMDSshort], 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. For more information, see Enable an Entity for Explicit Hierarchies and Collections (Master Data Services).

To create an explicit hierarchy

1. In [!INCLUDEssMDSmdm], click System Administration.

2. On the Model View page, from the menu bar, point to Manage and click Entities.

3. On the Entity Maintenance page, from the Model list, select a model.

4. Select the row for the entity that you want to create an explicit hierarchy for.

5. Click Edit selected entity.

6. On the Edit Entity page, in the Explicit hierarchies pane, click Add explicit hierarchy.

7. On the Add Explicit Hierarchy page, in the Explicit hierarchy name box, type a name for the hierarchy.

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

9. Click Save hierarchy.

10. On the Edit Entity page, click Save entity.

Next Steps

• Create a Consolidated Member (Master Data Services)

• Move Members within a Hierarchy (Master Data Services)

See Also

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