Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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 new record to something else, and then publish (you can leave comments as well).

  4. Perform step 3 again with new names.

  5. Right-click on value in the Name column of the new record (the cell that you've made changes to in step 3 and 4), and then click on View...