none
Modeling many-to-many relationships in MDS

    Question

  • Hello,

    I am creating my MDS model and entities and ran into this issue. I created a Vendor entity and Warehouse entity in MDS and created the related attributes. As per our data model I need to create a relationship between Vendor and Warehouse i.e., a Vendor owns zero or more Warehouses similarly a Warehouse can be owned by one ore more Vendors. If this is a one-to-one relationship I believe I could use the domain based attribute concept to establish the relationship.

    1) For implementing many-to-many relationship between two entities do I need to create a "new relationship" entity?

    2) In MDS by default an entity has a Name and Code attributes. How do I model this relationship entity such that the primary keys for this entity are the Vendor ID and Warehouse ID?

    3) In MDS Data Explorer how can I ensure that the users consistently enter data in all three entities - Vendor, Warehouse, Vendor-Warehouse relationship entity? Right now a user can enter data for Vendor or Warehouse entity and stop. But I would like the web app to create a wizard process such that a user enters all the data in all three entities to establish the relationship.

    Thanks.

    Thursday, April 04, 2013 5:03 PM

Answers

All replies

  • Hello,

    For question 1) and 2) you just use MDS as a usual database : http://social.technet.microsoft.com/wiki/contents/articles/mapping-multiple-systems-with-master-data-services.aspx

    Question 3) I think that you just can't if you stick with the default silverlight wepApp, you should use your own code and create the members programmatically.

    Regards,


    • Edited by Olivier Pothin Friday, April 05, 2013 9:15 AM
    • Marked as answer by ACK801 Friday, April 05, 2013 7:24 PM
    Friday, April 05, 2013 9:15 AM
  • Hello,

    To the first question - yes, you need a relationship entity.

    To the second question - I'll suggest that you create a business rule with a Must be Unique action -  i.e., an action that checks if the Vendor and the Warehouse are unique.

    To the third question - I agree with Olivier, there is no easy way to do this just with the silverlight app.

    Kind regards,

    M

    Friday, April 05, 2013 10:36 AM