| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|
Create a Subscription View to Export Data |
Learn how to create a subscription view to export Master Data Services data to subscribing systems, which creates a view of your data. |
CordeliaGrey |
jiwang6 |
03/01/2017 |
sql |
master-data-services |
how-to |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
Create a subscription view to export Master Data Services data to subscribing systems. You're creating a view of your data in the [!INCLUDEssMDSshort] database.
To perform this procedure:
-
You must have permission to access the Integration Management functional area. For more information, see Functional Area Permissions (Master Data Services).
-
You must be a model administrator. For more information, see Administrators (Master Data Services).
-
In [!INCLUDEssMDSmdm], click Integration Management.
-
From the menu bar, click Create Views.
-
On the Subscription Views page, click Add to create a view or click Edit to edit a view. A panel displays on the right side.
-
In the Create Subscription View pane, in the Name box, type a name for the view.
In the Edit Subscription View pane, in the Name box, type the updated name for the view.
-
From the Model list, select a model.
-
Select Include soft-deleted members, to include soft-deleted members in the view.
-
Select either Version or Version Flag in Version Options, and then select from the corresponding list.
[!TIP]
Create a subscription view based on a version flag. When you lock a version, you can reassign the flag to an open version without updating the subscription view. -
Select either Entity or Derived hierarchy in the Data Sources option, and then select from the corresponding list.
-
From the Format list, select a subscription view format.
-
If you chose Explicit levels or Derived levels from the Format list, type the number of levels in the hierarchy to include in the view.
-
Click Save.
For each created view, a row with ten columns is added to the grid. The following table describes the columns.
| Column | Description |
|---|---|
| Status | The view status. When you click Save, the  image displays, indicating that the view is updating.If there are errors when creating or editing a view, the  image displays.Otherwise, the status is OK and the  image displays. |
| Name | The subscription view name. |
| Model | The model name. |
| Version | The version name. |
| Version Flag | The version flag name. |
| Derived Hierarchy | The derived hierarchy name. |
| Entity | The entity name. |
| Format | Specifies the type of the data in the view. |
| Level | Specifies the number of levels in the view, which is only used for Explicit level or Derived level view formats |
| Include delete members | Indicates whether soft-deleted members are included in the view. |
When you click a view, the following information displays.
-
Created By: The name of the user who created the view.
-
On: The date and time when the view was created.
-
Updated By: The name of the user who last updated the view.
-
On: The date and time when the view was last updated.
Overview: Exporting Data (Master Data Services)
Delete a Subscription View (Master Data Services)
Create a Version Flag (Master Data Services)