Databases Reference
In-Depth Information
4. A new column with the title French (France) is added as shown in
Figure 5-26
.
Click the row English Country Region Name on the
column French (France). You now see the Attribute Data Transla-
tion dialog. Select the French Country Region Name column and
click OK.
Figure 5-26
5.
Repeat steps 1 through 4 for the language Spanish (Spain).
You have now created two translations in French and Spanish languages. In ad-
dition to specifying the columns for member names, you can also change the
metadata information of each level. For example, if you want to change the level
Country in the Geography hierarchy in French and Spanish languages, you can do
that by entering the names in the row that show the Country level. Type
Pays
and
Pais
as shown in
Figure 5-26
for French and Spanish translations respectively. You
have defined translations for the Country attribute in two languages making use of
the columns in the relational data source. To see how this metadata information is
shown in the dimension browser, first deploy the project to your Analysis Services
instance.
To see the effect of the translations you have created, select language
French (France) from within the Dimension Browser as shown in
Figure
5-27
. Select the Geography hierarchy and expand the All level. Now you
can see all the members in French. If you click any of the countries, the
metadata shown for the level is "Pays" (French for country) as shown in
Figure 5-27
.
There is a negligible amount of overhead associated with
Search WWH ::
Custom Search