Hide or Delete Levels in a Derived Hierarchy (Master Data Services)
Applies To: SQL Server 2016 Preview
In Master Data Services, 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).
To hide or delete levels in a derived hierarchy
In Master Data Services, click System Administration.
On the Model View page, 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 selected derived hierarchy.
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.