| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Validation |
Data is validated to ensure its accuracy, either automatically or based on business rules that you create in Master Data Services. |
CordeliaGrey |
jiwang6 |
03/14/2017 |
sql |
master-data-services |
conceptual |
[!INCLUDE SQL Server - Windows only ASDBMI]
In [!INCLUDEssMDSshort], data is validated to ensure its accuracy. Some validation occurs automatically, and other validation is based on business rules that are created by administrators.
Validation occurs at different times, and is displayed differently in the [!INCLUDEssMDSshort] 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 [!INCLUDEssMDSmdm] 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 | [!INCLUDEssNoVersion] or [!INCLUDEssMDSshort] | 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 [!INCLUDEssMDSXLS]. | Apply Business Rules (MDS Add-in for Excel) |