Subscription View Formats (Master Data Services)

 

Applies To: SQL Server 2016

Based on the entity or derived hierarchy you select, the following formats are available for your subscription view.

NameDescription
Leaf MembersContains leaf members and their associated attribute values.
Leaf Members HistoryContains leaf members’ historical data and the associated attribute values. The view format is Slowly Changing Dimension Type 4 style.
Leaf Members SCD Type 2Contains leaf members’ historical and current data, and the associated attribute values. The view format is Slowly Changing Dimension Type 2 style.
Consolidated MembersContains consolidated members and their associated attribute values.
Consolidated Members HistoryContains consolidated members’ historical data and the associated attribute values. The view format is Slowly Changing Dimension Type 4 style.
Consolidated Members SCD Type 2Contains consolidated members’ historical and current data, and the associated attribute values. The view format is Slowly Changing Dimension Type 2 style.
Collection MembershipsContains a list of collections and their associated attribute values.
CollectionsContains a list of collections and the members in each, along with weight values and sort order.
Collection Members HistoryContains collection members’ historical data and the associated attribute values. The view format is Slowly Changing Dimension Type 4 style.
Collection Members SCD Type 2Contains collection members’ historical and current data, and the associated attribute values. The view format is Slowly Changing Dimension Type 2 style.
Explicit Parent ChildContains explicit hierarchy structures for an entity in a parent child format.
Explicit LevelsContains 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)

Community Additions

ADD
Show: