Apply Business Rules (MDS Add-in for Excel)
Applies to: SQL Server - Windows only Azure SQL Managed Instance
In the Master Data Services Add-in for Excel 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
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 Master Data Services Configuration Manager. For more information, see Business Rule Settings.
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
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin