hide-or-delete-levels-in-a-derived-hierarchy-master-data-services.md

title	Hide or Delete Levels in 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	derived hierarchies, hiding levels derived hierarchies, deleting levels
ms.assetid	e00582b9-9415-4b66-b4a7-9f590d83875f
author	lrtoyou1223
ms.author	lle

Hide or Delete Levels in a Derived Hierarchy (Master Data Services)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]

In [!INCLUDEssMDSshort], hide a level in a derived hierarchy when you require the level for grouping but you do not need to show the level. Delete a level when you do not want to use it for grouping.

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 hide or delete levels in 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 you want to edit.

5. Click Edit.

6. In the Current Levels pane:

   • To hide a level, click a level other than the top or bottom. From the Visible list, select No. Then click Save selected hierarchy item.

   • To delete the top level, click Delete selected hierarchy item. In the confirmation dialog box, click OK. You can delete the top level only.

See Also

Derived Hierarchies (Master Data Services)