Database Reference
In-Depth Information
left-hand corner. As with dimension-level translations, you will be asked to
choose the language.
2. Once the language is chosen, the tab will have a new column for specifying
the translated values for each measure group, measure, perspective, KPI, di-
mension name, action, and calculation.
3. Once you specify the necessary values, save the solution. You do not have
to reprocess the cube because translations are applied to metadata and not
the data.
4. You can choose the language you wish to see translations in while browsing
data using SSDT or SSMS. Translated values will only appear for the lan-
guages for which you defined translations.
5. To test the translations in Excel, define the pivot table as usual, next activate
the
Data
tab, and click on
properties
to edit
Connection definition
. Enter
the locale identifier for the language of choice, for example, you can append
the following to the connection string to see Spanish translations for the
Spain region:
Extended Properties="LocaleIdentifier=3082"
.
Search WWH ::
Custom Search