Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Overview of this book

Table of Contents (18 chapters)
Microsoft SQL Server 2008 R2 Master Data Services
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Creating business rules


We will now extend our sample Store model to include some new business rules, while drilling deeper into the various conditions and actions that are available in the business rules editor.

Creating the required attributes business rule

We will start off the examples in this chapter with something simple—namely enforcing that a number of attributes in our Store entity must be completed. This can be carried out by creating a business rule that has a Validation action, as we will now see by covering the steps outlined next:

  1. Navigate to the MDS home page and click on the System Administration function.

  2. Hover over the Manage menu and choose the Business Rules menu item.

  3. Click on the green plus icon to add a new business rule that will insert one line into the grid that will appear below.

  4. Click on the edit business rules button, which will cause the Edit Business Rule window to appear, as shown below:

  5. The Components pane in the top-left hand corner of the previous image is where...