Tabular Sync Descriptions

Applicable to: SSAS Multidimensional | SSAS Tabular | SSRS | SSIS | Common

Applicable to Tabular Compatibility Level:
SQL 2012 SP1 / SQL 2014 (1103) | SQL 2016 (1200) | SQL 2017 (1400)

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), BI Developer Extensions 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…

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.

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:

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.