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

Business rules


Every data structure requires the functionality to define business rules and constraints. Business rules will help business users keep data consistent, reliable, and in the scope of the business. MDS, as a master data management solution, provides an extensive business rules model to write down business logic into expressions for better data management.

Multiple business rules can be created for each entity. Each business rule has a conditional clause and a then clause. The condition clause defines the situation in which the business logic needs to be applied, and then defines what needs to be done as a business requirement in that situation.

Examples of business rules are: preventing a user from making specific changes (for example, age needs to be a numeric value between 0 and 150), creating calculated attributes (such as a full name, which is concatenated of the first and the last name), or even checking a condition and then starting a workflow.