Edit

Share via

View All Annotations or Transactions for a Member (MDS Add-in for Excel)

Applies to: SQL Server - Windows only Azure SQL Managed Instance

Important

Master Data Services (MDS) is removed in SQL Server 2025 (17.x) Preview. We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.

In the Master Data Services Add-in for Excel, view annotations (comments) and transactions for rows of data (members) when you want to view updates to the data over time.

Prerequisites

To perform this procedure:

  • You must have an active worksheet that contains MDS-managed data.

  • The entity Transaction Log Type must be Member or Attribute.

To view annotations or transactions

  1. Click a cell in the row that contains transactions you want to view.

  2. Right-click and from the menu that's displayed, click View Transactions or View History.

  3. In the View Transactions dialog box, the list of transactions is displayed. To view all annotations associated with a transaction, click a row in the grid.

See Also

Overview: Importing Data from Excel (MDS Add-in for Excel)