Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Delete a Member or Collection (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, delete a member or collection when you no longer need it. If you want to delete members in bulk, use the staging process instead. For more information, see Deactivate or Delete Members by Using the Staging Process (Master Data Services)

Note Note

You cannot delete a member if it is used as a domain-based attribute value for another member.

To perform this procedure:

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

  • For members, you must have a minimum of Delete permission to the leaf model object you are deleting a member from.

  • For collections, you must have a minimum of Update permission to the leaf collection object you are deleting.

To delete a member or collection

  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. To delete:

    • A leaf member, from the menu bar, point to Entities and click the name of the entity that contains the member.

    • A consolidated member, from the menu bar, point to Hierarchies and click the name of the hierarchy that contains the member. Then click the node in the hierarchy that contains the member.

    • A collection, from the menu bar, point to Collections and click the name of the entity that contains the collection.

  5. In the grid, click the row of the member or collection you want to delete.

  6. Click Delete Member, Delete, or Delete Collection.

  7. In the confirmation dialog box, click OK.

Community Additions

ADD
Show:
© 2015 Microsoft