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

Hierarchies (Master Data Services)


Applies To: SQL Server 2016 Preview

In Master Data Services, a hierarchy is a tree structure that you can use to:

  • Group similar members for organizational purposes.

  • Consolidate and summarize members for reporting and analysis.

Each hierarchy contains members from one or more entities. When a member is added, changed, or deleted, all hierarchies are updated. This ensures that the data is accurate in all hierarchies. Hierarchies also help ensure that each member is counted once and only once.

If you want to create a grouping of a subset of members, consider using a collection. For more information, see Collections (Master Data Services).

You can create multiple hierarchies to view and organize your members in different ways. You can create:


All members in a hierarchy must be within the same model.

A hierarchy is different from a taxonomy. A taxonomy organizes members by multiple attributes at the same time, while a hierarchy organizes members by one attribute at a time. A taxonomy can include the same member multiple times, while a hierarchy includes a member only once.

For example, the same bike can be included in a taxonomy twice: once because it's red, and once because it's a size 38. In a hierarchy, the bike is included only once, so you must decide whether to show it in relation to its color or its size.

In the following example, product members are grouped by subcategory members.

Hierarchy Grouped by Subcategory Example

Task Description


Enable an entity for explicit hierarchies and collections.

Enable an Entity for Explicit Hierarchies (Master Data Services)

Create a explicit hierarchy.

Create an Explicit Hierarchy (Master Data Services)

Create a derived hierarchy.

Create a Derived Hierarchy (Master Data Services)

Hide or delete levels in an existing derived hierarchy.

Hide or Delete Levels in a Derived Hierarchy (Master Data Services)

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft