Members (Master Data Services)
Applies To: SQL Server 2016
In Master Data Services, members are the physical master data. For example, a member can be a Road-150 bike in a Product entity or a specific customer in a Customer entity.
You can think of members as rows in a table. Related members are contained in an entity, and each member is defined by attribute values.
In this example, the table represents an entity, the rows in the table represent members, and the columns in the table represent attributes. Each cell represents an attribute value for a specific member.
There are three types of members: leaf members, consolidated members, and collection members.
Leaf members are the default members in an entity.
In derived hierarchies, leaf members are the only type of member. Leaf members from one entity are used as parents of leaf members from another entity.
In explicit hierarchies, leaf members are the lowest level and cannot have children.
Consolidated members exist only when explicit hierarchies and collections are enabled for the entity.
Derived hierarchies do not contain consolidated members.
In explicit hierarchies, consolidated members can be parents of other members within the hierarchy, or they can be children.
In the following example, each member is made up of a Name, Code, Subcategory, StandardCost, ListPrice, and FilePhoto attribute value.
|Create a new leaf member.||Create a Leaf Member (Master Data Services)|
|Create a new consolidated member.||Create a Consolidated Member (Master Data Services)|
|Delete an existing member or collection.||Delete a Member or Collection (Master Data Services)|
|Reactivate a deleted member or collection.||Reactivate a Member or Collection (Master Data Services)|
|Update the attribute values of a member.||Change the Attribute Type (MDS Add-in for Excel)|
|Move members within a hierarchy.||Move Members within a Hierarchy (Master Data Services)|
|Fix merge conflicts.||Merge Conflicts (Master Data Services)|