Create a Consolidated Member

Create a Consolidated Member (Master Data Services)


Applies To: SQL Server 2016 Preview

In Master Data Services, create a consolidated member when you want a parent node for an explicit hierarchy. If you want to add data in bulk, use the staging tables instead. For more information, see Add, Update and Delete Data (Master Data Services).


To perform this procedure:

  • You must have permission to access the Explorer functional area.

  • You must have a minimum of Update permission to the consolidated model object for the entity you are adding a member to, as well as Create permission to Consolidated Type under the entity.

To create a consolidated member

  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. From the menu bar, point to Hierarchies and click the name of the hierarchy you want to add a consolidated member to.

  5. Above the grid, select either the Consolidated members or the All consolidated members in hierarchy option.

  6. In the left-hand pane, select either a Root node or a consolidated member under which you want to create a consolidated member.

  7. Click Add.

  8. In the pane on the right, complete the fields.

  9. Optional. In the Annotations box, type a comment about why the member was added. All users who have access to the member can view the annotation.

  10. Click OK.

Community Additions

© 2015 Microsoft