delete-a-derived-hierarchy-master-data-services.md

description	Delete a Derived Hierarchy (Master Data Services)
title	Delete a Derived Hierarchy
ms.custom
ms.date	03/01/2017
ms.prod	sql
ms.prod_service	mds
ms.reviewer
ms.technology	master-data-services
ms.topic	conceptual
helpviewer_keywords	deleting derived hierarchies [Master Data Services] derived hierarchies, deleting
ms.assetid	f46d660e-47f2-47ca-9372-1b5931540beb
author	CordeliaGrey
ms.author	jiwang6

Delete a Derived Hierarchy (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI ]

In [!INCLUDEssMDSshort], delete a derived hierarchy when you are sure you no longer need it.

Note

Deleting a derived hierarchy has no effect on the attribute relationships that the hierarchy is based on.

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 a derived hierarchy

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

2. From the menu bar, point to Manage and click Derived Hierarchies.

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

4. Select the row for the derived hierarchy that you want to delete.

5. Click Delete.

6. In the confirmation dialog box, click OK.

See Also

Create a Derived Hierarchy (Master Data Services)
Derived Hierarchies (Master Data Services)