Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Subscription View Formats
Collapse the table of content
Expand the table of content

Subscription View Formats (Master Data Services)

 

Applies To: SQL Server 2016 Preview

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.

Community Additions

ADD
Show:
© 2015 Microsoft