Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services

Problem Statement

In Master Data Services, a business rule is a rule that you use to ensure the quality and accuracy of your master data.

Is it possible to have a business rule to ensure the uniqueness of value for a combination of columns (Composite key).

Solution

1. Within the Master Data Service (MDS) homepage, Go to Administrative Tasks
   
2. Click on Manage >> Business Rules
   
3. Select the Model and Entity within which you need to add the Business Rule. And Click on Add.
   
4. Provide the Name and Description for the Business Key and Click on Add section within Then
   
5. Select the Attribute ( one column ) and Operator as : Must be Unique in Combination with the following attributes.
   
   Post that select the other Columns which are part of Composite key (other columns that needs to be added as part of uniqueness) and Click Add. Finally, Click on Save.
6. Click on Save to Create the Business Rule.
   
7. The Business Rule would be in Activation Pending State
   
   To Activate it, Click on Publish All.
   
   Post this, the Business Rule would in Active state:
   

Output

1. Composite Key is Unique
   
2. Composite Key is Duplicate