Automatically Generate Attribute Values Other Than Code (Master Data Services)
Applies To: SQL Server 2016
In Master Data Services, automatically generate values for an entity’s attribute values when you want an integer to be automatically assigned as the value each time business rules are applied.
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).
A numeric attribute must exist. For more information, see Create a Numeric Attribute (Master Data Services).
In Master Data Manager, 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, leave the default of All.
Click Add business rule.
Click Edit selected business rule.
In the Components pane, expand the Actions node.
In the Default Value node, click defaults to a generated value and drag it to the THEN pane’s Actions label.
In the Attributes pane, click the attribute with the value you want to generated and drag it to the Edit Action pane's Select attribute label.
Type a value in the Start with and Increment by boxes. If members already exist, the value will be set based on the highest existing value. For example, if the highest existing value is 299 and you set Increment by to 1, the next member’s value will be set to 300.
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.