Validation (Master Data Services)

In Master Data Services, data is validated to ensure its accuracy. Some validation occurs automatically, and other validation is based on business rules that are created by administrators.

When Data Validation Occurs

Validation occurs at different times, and is displayed differently in the Master Data Services web application.

Validation Type Standards Determined by When it Occurs Displayed in the MasterData Manager web UI as Displayed in the Add-in for Excel as Is Data Saved to the MDS Repository?
Business rule validation An MDS administrator Automatically when a user adds or edits data.

Manually when a user applies business rules.

Manually when an administrator in the Version Management functional area of the Master Data Manager web application validates a version against business rules.
Validation Errors ValidationStatus Yes
Data type and content validation An MDS administrator, when creating model objects (for example, an attribute’s length or data type) Automatically when a user adds or edits data Input Errors InputStatus No
Data type and content validation SQL Server or Master Data Services Automatically when a user adds or edits data Input Errors InputStatus No
Task Description Topic
Create business rules and publish them, so that data is validated against them. Create and Publish a Business Rule (Master Data Services)
Validate a version of data against business rules. Administrators only. Validate a Version against Business Rules (Master Data Services)
Validate specific subsets of data against business rules. All users with permission to the Explorer functional area. Validate Specific Members against Business Rules (Master Data Services)
Validate specific subsets of data against business rules. All users with permission to the Explorer functional area and using the Add-in for Excel. Apply Business Rules (MDS Add-in for Excel)

See Also

Business Rules (Master Data Services)