Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Time for action – creating a simple business rule


In this example, we will create a business rule for standard cost, which cannot be less than zero. This will help the master data be more reliable and protected from data entry faults.

  1. Open the WebUI for MDS. Go to System Administration.

  2. From the Manage menu, click on Business Rules. Choose the Product entity and add a new business rule.

  3. Double-click on the new record's name value and change it to StandardCost greater than zero. Then click on the Edit Selected Business Rules button on the top of the grid.

  4. You will be redirected to the Edit Business Rule window, which is the expression designer for business rules.

  5. From the Components area, under Actions and Validation, drag-and-drop must be greater than into the Expression Then area on Actions.

  6. Select must be greater than in the actions window of the Then area, and then from the Attributes area, drag-and-drop the StandardCost window to the Edit Action area right before must be greater than, as shown...