apply-business-rules-mds-add-in-for-excel.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Apply Business Rules	Apply Business Rules (MDS Add-in for Excel)	CordeliaGrey	jiwang6	03/01/2017	sql	master-data-services	how-to	microsoft-excel-add-in

Apply Business Rules (MDS Add-in for Excel)

[!INCLUDE SQL Server Windows Only - ASDBMI]

In the [!INCLUDEssMDSshort] [!INCLUDEssMDSXLS] apply business rules when you want to validate data and confirm that it is valid. You can correct validations and re-publish the data.

Note

Data validation occurs automatically when you publish data. For more information, see Validation (Master Data Services).

Prerequisites

To perform this procedure:

• You must have access to the Explorer functional area.

• You must have an active worksheet that contains MDS-managed data.

To apply business rules

1. In the Publish and Validate group, click Apply Rules.

   [!NOTE]
   The number of members (rows) that are validated at one time depends on a setting in [!INCLUDEssMDScfgmgr]. For more information, see Business Rule Settings.

2. The data is validated against business rules and two status columns are displayed. If these columns are not displayed automatically, in the Publish and Validate group, click Show Status to view them.

See Also

Overview: Importing Data from Excel (MDS Add-in for Excel)