Deactivate or Delete Members by Using the Staging Process (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, 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.
You cannot use staging to reactivate members. You must do it manually in the Master Data Services web application. For more information, see Reactivate a Member or Collection (Master Data Services).
You cannot use staging to delete or deactivate collections. For more information on manually deactivating collections, see Delete a Member or Collection (Master Data Services).
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
Follow the procedure to load or update members. For more information, see Load or Update Members in Master Data Services by Using the Staging Process. For the ImportType field, use 3 to deactivate members, and 4 to permanently delete.