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

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.


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