This project has moved and is read-only. For the latest updates, please go here.

Tabular Sync Descriptions

This page has been moved to GitHub and can be found here.

In a SQL Server relational database, you can add descriptions to tables and columns using extended properties. Commonly, the MS_Description extended property is used, but other extended properties can be used. If you have spent considerable time entering descriptions for relational tables and columns (for example, using the Kimball Dimensional Modeling Spreadsheet), BIDS Helper Tabular Sync Descriptions can help you import those descriptions to the table in your Tabular model in Analysis Services.

In the diagram view, right click on the name of a table and choose Sync Descriptions...

TabularSyncDescriptionsMenu.png

Then a window pops up showing you all the extended properties in the relational database. Choose the extended property used as the description. Then choose any additional columns that you would like to show in the description.

SyncDescriptionsPopup.png

Let's say you have a column with the MS_Description property set to "The geographic region of the country" and the "Example Values" property set to "North, East, South, West". The description property for the corresponding column in the table in Analysis Services will be set to:

The geographic region of the country
Example Values: North, East, South, West

Descriptions are applied to the table itself and to columns within that table. Descriptions are only applied to regular columns, not calculated columns or measures.

Considering that the Description property appears in a tooltip in the Power View field list, setting descriptions is a key to building a self-documenting model which is easy for business users to use for ad-hoc reporting:

TabularSyncDescriptionsPowerViewFieldList.png

This feature leverages the same code as the Sync Descriptions feature for Multidimensional models.

Limitations:
  • Only SQL Server relational databases are supported.
  • Currently, the sync only works in one direction. You can only sync relational database descriptions into Analysis Services.
  • Currently, Sync Descriptions only operates on Analysis Services tables in a Tabular model, not calculated columns or measures.

Last edited Oct 2 at 4:33 AM by furmangg, version 7