Many organizations have the need to work in a multi-lingual environment. There maybe a requirement that a Swedish speaking user should be able to browse the cube in their native tongue. Instead of creating separate cubes for each language to satisfy this requirement, Analysis Services has the possibility to work with translations. A translation can not only be the translation of the cube or database structure, but also of the data itself. The language displayed to the user is dependent on the settings on the user's workstation. To create a translation, you can perform the following steps:
Double-click on the Adventure Works DW2012.cube cube in the Solution Explorer.
Click on the Translations tab in the designer and then click on the New Translation button.
Select the appropriate language (in my case I chose Swedish) and click on OK.
In the column for the new translation, add the names for the different objects in your cubes in the selected...