Skip to content

create-a-consolidated-member-master-data-services.md

Latest commit

 

History

History
59 lines (41 loc) · 2.75 KB

create-a-consolidated-member-master-data-services.md

File metadata and controls

59 lines (41 loc) · 2.75 KB
title Create a Consolidated Member
description Create a Consolidated Member (Master Data Services)
author meetdeepak
ms.author dkhare
ms.reviewer mikeray
ms.date 03/05/2026
ms.service sql
ms.subservice master-data-services
ms.topic how-to
ms.custom
build-2025
helpviewer_keywords
creating consolidated members [Master Data Services]
members [Master Data Services], creating consolidated members
consolidated members [Master Data Services], creating

Create a Consolidated Member (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

In [!INCLUDEssMDSmdm], 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 Import Data from Tables (Master Data Services).

Prerequisites

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 [!INCLUDEssMDSmdm] 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.

See Also

Create an Explicit Hierarchy (Master Data Services)
Create a Leaf Member (Master Data Services)
Members (Master Data Services)
Explicit Hierarchies (Master Data Services)