Share via

Task 6: Verify that the Domain-Based Attribute is Created using Master Data Manager

  • Article

In this task, you verify that the State entity is created in MDS and the State attribute of the Supplier entity is a domain-based attribute that depends on the State entity by using Master Data Manager.

  1. Switch to the Master Data Manger web application.

  2. Click SQL Server 2012 Master Data Services at the top to get to the home page.

  3. Ensure that Suppliers model is selected and click Explorer. You could refresh the page if you already had Explorer open.

  4. Hover your mouse over Entities on the menu bar and notice that now there are two entities: Supplier and State.

    Entities Menu with State and Supplier

  5. Click State if the entity is not open already.

  6. Select GA from the list.

  7. In the Details pane to the right, change the Name to Georgia in the right pane, and click OK.

  8. Repeat the previous steps for other states.

    Code

    Name

    CA

    California

    CO

    Colorado

    IL

    Illinois

    DC

    District of Columbia

    FL

    Florida

    AL

    Alabama

    KY

    Kentucky

    MA

    Massachusetts

    AZ

    Arizona

    MI

    Michigan

    MN

    Minnesota

    NJ

    New Jersey

    NV

    Nevada

    NY

    New York

    OH

    Ohio

    OK

    Oklahoma

    OR

    Oregon

    PA

    Pennsylvania

    SC

    South Carolina

    KS

    Kansas

    TN

    Tennessee

    TX

    Texas

    UT

    Utah

    VA

    Virginia

    WA

    Washington

    WI

    Wisconsin

    HI

    Hawaii

    MD

    Maryland

    CT

    Connecticut

  9. Select any of the state entries and click View Transactions from the Toolbar. You should see the transaction for the update you just made is in the list of transactions.

  10. Hover the mouse over Entities menu and click Supplier.

  11. Now, notice that a value for the State field can be changed in the Details pane by using the drop-down list. You can also see that, in the list to the left and in the drop-down list in the Details pane, code is displayed first and then the name in curly braces. You can also change any other value in the Details pane.

    State Attribute with Updated Code and Names

Next Step

Task 7: Viewing Updates Made using Master Data Manager in Excel