Move Members within a Hierarchy (Master Data Services)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

In Master Data Services, move members within a hierarchy to change their location or parent assignment.

To perform this procedure:

  • You must have permission to access the Explorer functional area.

  • For explicit hierarchies, you must have a minimum of Update permission to the entity.

  • For derived hierarchies, you must have a minimum of Read to the model and Update to any domain-based attributes used in the hierarchy.

To move members within a hierarchy

  1. On the Master Data Services home page, from the Model list, select a model.

  2. From the Version list, select a version.

  3. Click Explorer.

  4. From the menu bar, point to Hierarchies and click hierarchy_name.

  5. In the Hierarchy pane, where the hierarchy is displayed in a tree structure, click the check box for each member you want to move.

  6. At the top of the Hierarchy pane, click Cut.

  7. In the Hierarchy pane, click the check box for the member you want to move the members to.

    Or, click the corresponding hierarch level name under the Unused node for derived hierarchies.

  8. Click Paste.

    Note Note

    In derived hierarchies, you can move members to the same level only. Also, you cannot change the sort order of members.

Community Additions