Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Delete a Member or Collection

Delete a Member or Collection (Master Data Services)

 

Applies To: SQL Server 2016 Preview

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)

System_CAPS_noteNote

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

Prerequisites

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