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

APPLIES TO: yesSQL Server (Windows only) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

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:

To hide or delete levels in a derived hierarchy

  1. In Master Data Manager, 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)