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

title	Delete 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	explicit hierarchies, deleting deleting explicit hierarchies [Master Data Services]
ms.assetid	4ce177b0-9884-47a2-9cea-212e845dd762
author	lrtoyou1223
ms.author	lle
manager	craigg

Delete an Explicit Hierarchy (Master Data Services)

In [!INCLUDEssMDSshort], delete an explicit hierarchy when you no longer need it.

Warning

When you delete an explicit hierarchy, all consolidated members in the hierarchy are deleted also. If you delete all explicit hierarchies for an entity, all collections for the entity are also deleted and the entity is no longer enabled for explicit hierarchies and collections.

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

To delete 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 contains the explicit hierarchy you want to delete.

5. Click Edit selected entity.

6. On the Edit Entity page, in the Explicit Hierarchies pane, click the explicit hierarchy you want to delete.

7. Click Delete selected hierarchy.

8. In the confirmation dialog box, click OK.

9. In the additional confirmation dialog box, click OK.

See Also

Create an Explicit Hierarchy (Master Data Services)
Explicit Hierarchies (Master Data Services)