Analysis Services Tabular translations and Tabular model explorer

From 2012 we can see that Microsoft pay more attention to Analysis Services Tabular than Multidimensional. Cubes give us opportunity to build very cool and very complex models but right nothing happens to this piece of technology. So in SQL Server 2016 Tabular has much more new features than Multidimensional. In this article i will show you very shortly how to implement new feature called Translations in Tabular model – let’s get started!

In the beginning i would like to show you new Tabular Model Explorer. You can browse your model using this explorer but the first step is to enable it using path View-> Other windows-> Tabular model explorer – it should looks like this:

tabularmodelexplorer

New explorer tab should appear. You can use Search window to find object that you want. Additionally you can use “plus” and “minus” buttons to expand and collapse all folders.

tabularmodelexplorer2

Small thing but using this feature is very simple and it is much better to use than older approach. The only question that appear is why it wasn’t present in older versions of Tabular? Nobody knows.

So let’s go to the translations. As you probably know Translations give us opportunity to implement models in many languages. To create them we need to right click on the Translations folder in Tabular Model Explorer and click Manage Translations. Below window should appear

tabular_translations

Another step is to choose language that we need and move it to the left pane of the window and click Export selected language button. After that we need to open exported file in notepad for example. As you can see in the below window it has JSON format (everything in the newest Tabular has JSON format). To implement translations we need to find “translations”.  In this section we can provide translations of objects in the particular model. As you can see in the below screenshot – we can translate captions (using translatedCaption property) or description (using translatedDescription property). So you can give translation to all the objects that you want and save the file.

tabular_translations_json

In the next step you need to right click on the Translations folder in Tabular Model explorer and choose Import translations. New window will appear where we need to provide path to our translations file.

tabular_import_translations

If everything was configured correctly you should see message box with success message. To check you translation you can connect using Excel to your workspace database or just click Analyze in Excel button that you can find in the toolbox. The only thing that you need to change in Analyze in Excel is Culture – when you click this then you should see all the languages that has properly configured translations.

tabularmodelchooseculture

When Excel will open then in the PivotTable Fields you should see translated captions of your objects. For example in the below picture you can notice that one table is translated from DimCurrency to WymiarWaluta.

tabularmodeltranslationsinexcel

As you can see implementing translations in SQL Server Analysis Services Tabular 2016 is very simple. You can also use GUI to modify this file using external software (for example using this software). Of course there are more feature available in the newest version of Tabular that we will describe in the future. Stay tuned!

Leave a Comment

Your email address will not be published. Required fields are marked *