Microsoft SQL Server Master Data Services: Difference between revisions

Revision as of 15:43, 15 August 2013

Revision as of 03:08, 19 August 2013

Line 24:

* ''Attribute Groups'' are explicitly defined collections of particular attributes. Say you may have an entity (Customer)"customer" that is comprised ofhas 50 differentattributes attributes— too much information for many of your users. Attribute groups enable the creation of custom sets of hand-picked attributes that are relevant for specific audiences. (e.g. Customer"customer - Deliverydelivery Detailsdetails" that would include just their name and last known delivery address)

* ''Hierarchies'' organise members into either Derived or Explicit hierarchical structures. Derived hierarchies, as the name suggests, are derived by the MDS engine based on the relationships that exist between attributes. Explicit hierarchies are created by hand using both leaf and consolidated members.

* ''Business Rules'' can be created and applied against model data to ensure that custom business logic is adhered to. In order to be committed into the system data must pass all business rule validations applied to them. e.g. Within the Customer Entity you may want to create a business rule that ensures all members of the 'Country' Attribute contain either the text "USA" or "Canada". The Business Rule once created and ran will then verify all the data is correct before it accepts it into the approved model.