Events
Get certified in Microsoft Fabric—for free!
Nov 19, 11 PM - Dec 10, 11 PM
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare nowThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server - Windows only Azure SQL Managed Instance
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.
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.
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) |
Events
Get certified in Microsoft Fabric—for free!
Nov 19, 11 PM - Dec 10, 11 PM
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare now