Subscription View Formats (Master Data Services)
Applies to: 
SQL Server - Windows only
Azure SQL Managed Instance
Based on the entity or derived hierarchy you select, the following formats are available for your subscription view.
Subscription View Formats
| 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. |
See Also
Overview: Exporting Data (Master Data Services)
Create a Subscription View to Export Data (Master Data Services)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for