Any suggestions? Export (0) Print
Expand All

Create and Edit a Subscription View (Master Data Services)

 

Applies To: SQL Server 2016 Preview

Create a subscription view when you want to create a view of your data in the Master Data Services database for use by subscribing systems.

Prerequisites

To perform this procedure:

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 Icon for updating status image displays, indicating that the view is updating.

If there are errors when creating or editing a view, the Icon for error status image displays.

Otherwise, the status is OK and the Icon for OK status 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.

To create and edit a subscription view

  1. In Master Data Manager, click Integration Management.

  2. From the menu bar, click Create Views.

  3. 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.

  4. 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.

  5. From the Model list, select a model.

  6. Select Include soft-deleted members, to include soft-deleted members in the view.

  7. Select either Version or Version Flag in Version Options, and then select from the corresponding list.

    System_CAPS_tipTip

    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.

  8. Select either Entity or Derived hierarchy in the Data Sources option, and then select from the corresponding list.

  9. From the Format list, select a subscription view format.

  10. 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.

  11. Click Save.

Community Additions

ADD
Show:
© 2016 Microsoft