Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server - Windows only
Azure SQL Managed Instance
In Master Data Services, require attribute values when you want to ensure your master data is complete.
Note
Members that are missing domain-based attribute values are not displayed in derived hierarchies that are based on those relationships.
To perform this procedure:
You must have permission to access the System Administration functional area.
You must be a model administrator. For more information, see Administrators (Master Data Services).
In Master Data Manager, click System Administration.
From the menu bar, point to Manage and click Business Rules.
On the Business Rules page, from the Model drop-down list, select a model.
From the Entity drop-down list, select an entity.
From the Member Types drop-down list, select a type of member for the business rule to apply to.
Click Add.
In the Name box, type a name for the business rule.
Optionally, in the Description field, type the business rule description.
Under the Then block, click Add. A panel will be displayed.
From the Operator drop-down list, select required action.
From the Attribute drop-down list, select an attribute.
Click Save. A new row will be added to the Then grid.
Click Save.
Click Publish All.
On the confirmation dialog box, click OK. The value in the Business Rule State column is Active.
Apply business rules to data by following one of these procedures:
Business Rules (Master Data Services)
Derived Hierarchies (Master Data Services)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Define and create business rules in Microsoft Dataverse - Training
The ability to build business rules that ensure consistent business logic whatever app is accessing that data set is imperative to a successful business operation. This module will show you how you can build business rules that are triggered anytime they're used within Dataverse.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Validate Specific Members against Business Rules - SQL Server Master Data Services
Validate Specific Members against Business Rules (Master Data Services)
Business Rule Actions - SQL Server Master Data Services
In Master Data Services, business rules cause actions. Learn about default value actions, change value actions, validation actions, and external actions.
Create a Consolidated Member - SQL Server Master Data Services
Create a Consolidated Member (Master Data Services)