Export (0) Print
Expand All

Members (Master Data Services)

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.

Master Data Services Entity Represented as Table

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.

Hierarchies and collections can be used to group members for reporting or analysis. For more information, see Hierarchies (Master Data Services) and Collections (Master Data Services).

In the following example, each member is made up of a Name, Code, Subcategory, StandardCost, ListPrice, and FilePhoto attribute value.

Bike Product Entity Table

Task Description

Topic

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)

Community Additions

ADD
Show:
© 2014 Microsoft