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

Concepts

Business Rules (Master Data Services)