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)

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, 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