| title | Collections | ||
|---|---|---|---|
| description | Collections (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 | concept-article | ||
| ms.custom |
|
||
| helpviewer_keywords |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
[!INCLUDE support-notice]
A collection is a group of leaf and consolidated members from a single entity. Use collections when you do not need a complete hierarchy and you want to view different groupings of members for reporting or analysis, or when you need to create a taxonomy.
Note
Collection is deprecated.
Collections do not limit the number or type of members you can include, as long as the members are within the same entity. A collection can contain leaf and consolidated members from multiple mandatory and non-mandatory explicit hierarchies.
When you create a collection, you are not creating a hierarchical structure; you are creating a flat list of members. When you select a node from a hierarchy and add it to the collection, the consolidated member you selected is the only member added to the collection.
A collection can also contain other collections. You can use collections of collections to create taxonomies.
When you create a collection you are automatically listed as the owner. If you are an administrator, you can create other attributes for your collection as needed.
There are two types of subscription views that show collections. The Collection attributes format shows a list of collections and any attributes related to the collections (like description or owner). The Collections format shows all members in all collections, as well as each members weight and sort order. For more information, see Overview: Exporting Data (Master Data Services).
If you set weight values for specific members in a collection, these values are available in related subscription views.
| Task Description | Topic |
|---|---|
| Create a new collection. | Create a Collection (Master Data Services) |
| Add members to an existing collection. | Add Members to a Collection (Master Data Services) |