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.
- Open the WebUI for MDS. Go to System Administration.
- From the Manage menu, click on Business Rules. Choose the Product entity and add a new business rule.
- 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.
- You will be redirected to the Edit Business Rule window, which is the expression designer for business rules.
- From the Components area, under Actions and Validation, drag-and-drop must be greater than ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.