Today we will learn on how to change the language of Microstrategy Web Dossier visuals based on user's default language
For Labels and data, You have two options:
- You can create separate tables for each lanaguage (table level)
- You can create separate column with postfix in the same table for each language (e.g.: Column1_EN for english, Column1_NL for dutch)
For this experiment, will be using Column pattern for changing the data language
First, you need to add the new language for the Dutch user (in Microstrategy Developer):
- Set the default language to Dutch
- Set the number and date format to Dutch (used to change the locale)
- Set the I-Server language to Dutch (used when exporting reports)
- Enable “Data Internationalization” (to be enabled at project level in Microstrategy developer)
- Go to Project Settings > Language > Data
- Enable “SQL based”
- Add dutch language
- Let the English language be default
- In the column pattern, add “_DTCH” in from of Dutch language
- Leave column pattern for English as blank
- Refresh/Update the project