Skip to content

Latest commit

 

History

History
60 lines (42 loc) · 3.62 KB

validating-data-mds-add-in-for-excel.md

File metadata and controls

60 lines (42 loc) · 3.62 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom
Validating Data
Validating Data (MDS Add-in for Excel)
CordeliaGrey
jiwang6
03/01/2017
sql
master-data-services
conceptual
microsoft-excel-add-in

Validating Data (MDS Add-in for Excel)

[!INCLUDE SQL Server Windows Only - ASDBMI]

In the [!INCLUDEssMDSshort] [!INCLUDEssMDSXLS], when you publish data, two types of validation take place:

  • Any defined business rules are applied to the data.

  • Data is checked against allowed attribute values (for example, number of characters or type of data).

In each case, valid data is published to the MDS repository. Data that is not valid is highlighted, and details of the error can be shown in status columns.

When Validation Occurs

In the [!INCLUDEssMDSshort] [!INCLUDEssMDSXLS], validation occurs when you publish new or changed data, or when you manually apply business rules.

When business rules fail, the data is still published to the MDS repository. When input validation fails, the data is not published to the repository.

Validation Statuses

In the [!INCLUDEssMDSshort] [!INCLUDEssMDSXLS], the following validation statuses are possible.

For information about additional statuses, see Validation Statuses (Master Data Services)

Status Description
Validation Failed One or more values in the row failed validation against business rules defined by an MDS administrator.
Validation Succeeded All values in the row have passed validation against business rules.

Input Statuses

In the [!INCLUDEssMDSshort] [!INCLUDEssMDSXLS], the following input statuses are possible

Status Description
Error One or more values in the row don't meet system requirements like length or data type. The value is not updated in the MDS repository.
New Row The values in the row have not yet been published to the MDS repository.
Read Only The logged in user has Read-only permissions to one or more values in the row and the value(s) cannot be updated.
Unchanged No values in the row have been changed in the worksheet. This does not mean the values in the repository have not changed; to get the latest data in the sheet, in the Connect and Load group, click Load or Refresh.

This is the default setting for each row.

Related Tasks

Task Description Topic
Determine which values do not pass the defined business rules. Apply Business Rules (MDS Add-in for Excel)
To help correct validation errors, view all transactions that have taken place for a member. View All Annotations or Transactions for a Member (MDS Add-in for Excel)

Related Content