| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Subscription View Formats |
Subscription View Formats (Master Data Services) |
CordeliaGrey |
jiwang6 |
03/01/2017 |
sql |
master-data-services |
conceptual |
[!INCLUDE SQL Server - Windows only ASDBMI]
Based on the entity or derived hierarchy you select, the following formats are available for your subscription view.
| Name | Description |
|---|---|
| Leaf Members | Contains leaf members and their associated attribute values. |
| Leaf Members History | Contains leaf members' historical data and the associated attribute values. The view format is Slowly Changing Dimension Type 4 style. |
| Leaf Members SCD Type 2 | Contains leaf members' historical and current data, and the associated attribute values. The view format is Slowly Changing Dimension Type 2 style. |
| Consolidated Members | Contains consolidated members and their associated attribute values. |
| Consolidated Members History | Contains consolidated members' historical data and the associated attribute values. The view format is Slowly Changing Dimension Type 4 style. |
| Consolidated Members SCD Type 2 | Contains consolidated members' historical and current data, and the associated attribute values. The view format is Slowly Changing Dimension Type 2 style. |
| Collection Memberships | Contains a list of collections and their associated attribute values. |
| Collections | Contains a list of collections and the members in each, along with weight values and sort order. |
| Collection Members History | Contains collection members' historical data and the associated attribute values. The view format is Slowly Changing Dimension Type 4 style. |
| Collection Members SCD Type 2 | Contains collection members' historical and current data, and the associated attribute values. The view format is Slowly Changing Dimension Type 2 style. |
| Explicit Parent Child | Contains explicit hierarchy structures for an entity in a parent child format. |
| Explicit Levels | Contains explicit hierarchy structures for an entity in level format. |
| Derived Parent Child (Derived Hierarchy View) | Contains a derived hierarchy structure in parent child format. |
| Derived Levels (Derived Hierarchy View) | Contains a derived hierarchy structure in level format. |
Overview: Exporting Data (Master Data Services)
Create a Subscription View to Export Data (Master Data Services)