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

Deactivate or Delete Members by Using the Staging Process (Master Data Services)

 

Applies To: SQL Server 2016 Preview

In Master Data Services, you can deactivate members or delete them completely.

Deactivating means the member can be reactivated. If you reactivate a member, its attributes and its membership in hierarchies and collections are restored. All previous transactions are intact. Deactivation transactions are visible to administrators in the Version Management functional area of the Master Data Services web application.

Deleting means purging the member from the system permanently. All transactions for the member, all relationships, and all attributes are permanently deleted.

Notes:

Prerequisites

To perform this procedure:

  • You must have permission to insert data into the stg.name_Leaf (for leaf members) or stg.name_Consolidated (for consolidated members) table in the Master Data Services database.

  • You must have permission to execute either the stg.udp_name_Leaf (for leaf members) or stg.udp_name_Consolidated (for consolidated members) stored procedure in the Master Data Services database.

  • The model must not have a status of Committed.

To deactivate or delete members

Community Additions

ADD
Show:
© 2015 Microsoft