Extending and Customizing Cubes - SQL Server Analysis Services 2012 Cube Development - page 154

Defining translations
Analysis Services does not translate attributes or measure names for you, but it al-
lows you to specify your own translations in case your application will serve a mul-
tilingual audience. You can define translations for dimension attributes as well as
cube metadata. The Adventure Works sample multidimensional database supplies
French and Spanish translations. You can use either SSMS/SSDT or a cube browsing
tool of your choice to test translations.
How to do it...
To define translations for dimension attributes, the following steps need to be fol-
lowed:
1. Right-click on any database dimension within the SSDT project, and choose
open. Navigate to the Translations tab within the dimension designer.
2. Right-click anywhere within the Translations tab, and choose New Transla-
tion ; doing so will open a dialog box that allows you to choose the language
you will be using.
3. The Translations tab lists all the dimension attributes. Once you choose the
language, you will see a separate column where you can specify the values
for each attribute's translation.
4. When you click on each attribute, you will see a button on the right-hand side
of the cell. Click on the button to activate the Attribute Data Translation dia-
log shown in the following screenshot. In this example, the translation is spe-
cified for the day and name of the week in French by choosing the corres-
ponding column from the relational dimension table. Note that you could spe-
cify a translated caption in addition to supplying the value from the relational
column.