| title | Hide or Delete Levels in a Derived Hierarchy | ||
|---|---|---|---|
| description | Hide or Delete Levels in a Derived Hierarchy (Master Data Services) | ||
| author | meetdeepak | ||
| ms.author | dkhare | ||
| ms.reviewer | mikeray | ||
| ms.date | 03/05/2026 | ||
| ms.service | sql | ||
| ms.subservice | master-data-services | ||
| ms.topic | how-to | ||
| ms.custom |
|
||
| helpviewer_keywords |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
[!INCLUDE support-notice]
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.
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).
-
In [!INCLUDEssMDSmdm], click System Administration.
-
From the menu bar, point to Manage and click Derived Hierarchies.
-
On the Derived Hierarchy Maintenance page, from the Model list, select a model.
-
Select the row for the derived hierarchy you want to edit.
-
Click Edit.
-
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.
-