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
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
  2. Click on Manage >> Business Rules
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
  3. Select the Model and Entity within which you need to add the Business Rule. And Click on Add.
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
  4. Provide the Name and Description for the Business Key and Click on Add section within Then
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
  5. Select the Attribute ( one column ) and Operator as : Must be Unique in Combination with the following attributes.
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
    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.
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
  7. The Business Rule would be in Activation Pending State
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
    To Activate it, Click on Publish All.
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
    Post this, the Business Rule would in Active state:
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services

Output

  1. Composite Key is Unique
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
  2. Composite Key is Duplicate
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services
    Setting Business Constraint for Uniqueness of a Composite Key in Master Data Services


Similar Articles