Skip to content

Latest commit

 

History

History
56 lines (37 loc) · 3.22 KB

overview-exporting-data-master-data-services.md

File metadata and controls

56 lines (37 loc) · 3.22 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Exporting Data
Overview: Exporting Data (Master Data Services)
CordeliaGrey
jiwang6
03/14/2017
sql
master-data-services
concept-article
exporting data [Master Data Services]
subscription views [Master Data Services]
subscription views [Master Data Services], about subscription views

Overview: Exporting Data (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI]

This article introduces the types of subscription view formats and how to determine when views need to be edited due to changes to model objects.

You create a subscription view to export [!INCLUDEssMDSshort] data to a subscribing system such as [!INCLUDEssNoVersion]. You use the subscribing system to view the data in the [!INCLUDEssMDSshort] database. For information on how to create the subscription view, see Create a Subscription View to Export Data (Master Data Services)

For more information about views, see Views.

Subscription View Formats

When you create a view in [!INCLUDEssMDSmdm], you choose from a set of standard view formats that [!INCLUDEssMDSshort] provides. You can use these formats to create views that show:

  • All leaf members and their attributes.

  • All consolidated members and their attributes.

  • All collections and their attributes.

  • The members explicitly added to a collection.

  • The members in a derived hierarchy, in either a parent child or level format.

  • The members in all explicit hierarchies for an entity, in either a parent child or level format.

Subscription Views Can Become Out-of-Date

After you create a subscription view for an entity or hierarchy, changes to the associated model objects are not automatically reflected in the view. You might need to regenerate a subscription view in [!INCLUDEssMDSmdm] to reflect changes to model objects. The Changed column on the Export page is updated to True when model objects change. True indicates that you should edit the subscription view and save it, which regenerates the view.

Related Tasks

Task Description Topic
Create a subscription view of your master data. Create a Subscription View to Export Data (Master Data Services)
Delete an existing subscription view. Delete a Subscription View (Master Data Services)

Related Content