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, ...

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.