Dimension Design - Professional SQL Server Analysis Services 2005 with MDX - page 200

Defining Translations in Dimensions
If your data warehouse is to be used globally, you want to show the hier-
archies, levels, and members in different languages so that customers in
those countries can read the cube in their own language. Analysis Ser-
vices 2005 provides you with a feature called Translation (not a super-
imaginative name) that helps you create and view dimension members in
various languages. The benefit of this feature is that you do not have to
build a new cube in every language. For implementation you need to only
have a column in the relational data source that will have the translated
names for all the members of a a specific attribute in the dimension.
In the Dim Geography table you have two attributes: Spanish Country Region Name
and French Country Region Name. These columns have the translated names of
the country names which are members of the attributes English Country Region
Name. The following steps describe how to create a new translation:
1. Switch to the Translations tab in the Dimension Designer.
2. Click the New Translation icon shown in Figure 5-25 or choose New
Translation from the Dimension menu item to create a new trans-
lation and choose a language. The Selection language dialog now
pops up.
Figure 5-25
3. Select the language French (France) and click OK.