Time for action – change tracking

Change tracking is one of the useful features of MDS. Changes in any attribute values will be logged in the MDS database and are viewable using the Excel Add-in or WebUI. Users or a data steward may also insert comments on every change that occurs on the master data to make the tracking of changes even easier. In this example, we make some changes in an attribute value and then track the history of changes.

  1. Add a new member (record) at the end of the Product Category entity in the Excel Add-in.
  2. A new record will appear in a different color. You need to publish changes to save them back to MDS. You can insert comments when you publish it. After publishing, the color will change back.
  3. Change the Name column of the ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial