Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Creating Translations for Analysis Services Tabular 2016


By:   |   Read Comments   |   Related Tips: > Analysis Services Development

Attend these FREE MSSQLTips webcasts >> click to register


Problem

We just started using Analysis Services 2016 and we have created a Tabular model. One of the new features is the ability to add translations for the different metadata objects, however this requires editing some JSON file. Is there an easier way?

Solution

Translations is a new feature of Analysis Services (SSAS) Tabular 2016. You can now add translations supporting many different languages for different objects of a Tabular model such as: the name of the model, the table names, all the column names and the names of the various measures.

SSAS Multidimensional already supported translations for quite some time now. It also has the capability to translate metadata, but you can also specify alternative translation columns for the actual data (for example, English Product Name, French Product Name, Spanish Product Name and so on). Tabular doesn’t support this at the moment, you cannot translate the actual data, only the metadata.

An introduction to translations in SSAS Tabular can be found in the tip Multi-language support for SSAS Tabular Models. In this tip we’ll focus on creating translations using the open-source tool SSAS Tabular Translator, created by Kasper de Jonge, which can be downloaded for free at Github. With this tool, the burden of manually editing JSON files has been removed, you can simply edit the translations in a table-like editor.

Creating a Translation with the Tabular Translator

The first step is to create a translation file. Navigate to Model > Translations > Manage Translations.

create translation

In the dialog, select the language for which you want to create a translation:

select language for translation

Add the language to the model and click on Export selected languages. You can now save a template for the translation as a JSON file.

export language

Open the Tabular Translator tool and import the just created JSON file.

open translation file

Make sure the culture in the header matches the language from the translation. In the table, you can find all the metadata objects of the model: the name of the model itself, the table names, the column names and the names of the measures.

the SSAS Tabular Translator

The editor allows you to easily specify the following properties:

  • TranslatedCaption
  • TranslatedDescription
  • TranslatedDisplayFolder

The editor lists the type of the object, along with the name, description and the display folder of the object. You cannot change any of the original properties though.

Let’s create some translations for the City table:

create translations in editor

Click the button Save Updates. We can verify in the JSON file that the translations have been added.

translations in JSON file

Now we can import the translations back into the model. Navigate to Model > Translations >  Import Translations. If the translation already exists for the specified language, we’re going to overwrite it.

import translation file

We can easily test the translation with the Analyze in Excel functionality.

analyze in excel

In the pop-up, make sure to select the correct culture before launching Excel:

select correct culture

We can view the results of the translation in a Pivot Table:

pivot table fields

Conclusion

With the SSAS Tabular Translator, we can easily create translations without manually editing a JSON file. Make sure you don’t change the name of the original objects when you’re editing a translation, or a mismatch might occur.

Next Steps


Last Update:


signup button

next tip button



About the author
MSSQLTips author Koen Verbeeck Koen Verbeeck is a BI professional, specializing in the Microsoft BI stack with a particular love for SSIS.

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools