Require Attribute Values (Master Data Services)
Applies To: SQL Server 2016 Preview
In Master Data Services, require attribute values when you want to ensure your master data is complete.
Members that are missing domain-based attribute values are not displayed in derived hierarchies that are based on those relationships.
To perform this procedure:
You must have permission to access the System Administration functional area.
You must be a model administrator. For more information, see Administrators (Master Data Services).
To require attribute values
In Master Data Services, click System Administration.
From the menu bar, point to Manage and click Business Rules.
On the Business Rule Maintenance page, from the Model list, select a model.
From the Entity list, select an entity.
From the Member Type list, select a type of member for the business rule to apply to.
From the Attribute list, select an attribute or leave the default of All.
Click Add business rule.
Click Edit selected business rule.
In the Components pane, expand the Actions node.
Click is required and drag it to the THEN pane's Action label.
In the Attributes pane, click an attribute and drag it to the Edit Action pane's Select attribute label.
In the Edit Action pane, click Save item.
Optionally, on the Business Rules Maintenance page, for the row that contains your business rule, double-click a cell in the Name, Description, or Notification column to update the value.
Click Publish business rules.
On the confirmation dialog box, click OK. The rule's status changes to Active.
Apply business rules to data by following one of these procedures: