Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

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.

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)

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.