Move Explicit Hierarchy Members by Using the Staging Process (Master Data Services)

  • Article

In Master Data Services, you can use the staging process to move the location of members in explicit hierarchies in bulk. You can designate:

  • A consolidated member as a parent of a consolidated member.

  • A consolidated member as a parent of a leaf member.

  • A leaf member as a sibling of a leaf or consolidated member.

  • A consolidated member as a sibling of a leaf or consolidated member.

Prerequisites

To perform this procedure:

  • You must have permission to insert data into the stg.name_Relationship table in the Master Data Services database.

  • You must have permission to execute the stg.udp_name_Relationship stored procedure in the Master Data Services database.

  • The model must not have a status of Committed.

To move explicit hierarchy members

  1. Prepare the members for import into the stg.name_Relationship table in the Master Data Services database. For more information about the required fields, see Relationship Staging Table (Master Data Services).

  2. Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.

  3. Import the data into stg.name_Relationship. For information about importing data into a database by using SQL Server Integration Services, see Run the SQL Server Import and Export Wizard.

  4. After you successfully import the data, run the stg.udp_name_Relationship stored procedure to load the staged data into the appropriate MDS tables. For more information about the stored procedure, see Staging Stored Procedure (Master Data Services)

Next Steps

See Also

Tasks

Move Members within a Hierarchy (Master Data Services)

Concepts

Importing Data (Master Data Services)

Staging Process Errors (Master Data Services)

Other Resources

Troubleshooting the Staging Process (Master Data Services)