Microstrategy Web Dossier - Data Internationalization

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

• Create a Test - Dutch user
• Give the user access to Microstrategy 
• Set the user language preferences to Dutch (from Microstrategy Developer)

Steps to display the data for a column based:

1. Create a new dossier from Microstrategy Web. 

2. Create a SQL table "dataset1" that has below columns and fill some random data:

• Variety
• Current datetime
• Adate
• Description
• Description_NL

3. In the Microstrategy web > dossier, add a new dataset "dataset1" (SQL table created above)

4. Go to Microstrategy Developer and perform the below steps:

• Create an attribute "Variety" in the Schema Objects\Attributes folder 
• Add ID (variety ID) and Description from the dataset1 (created above)

• Tick mark the option "Supports multiple language" for Description column
• This will automatically change the description based on user's language

5. Go to the dossier you created and perform the below steps:

• Add the newly created attribute
• Right click '+' sign (where you add a dataset) and select "Existing objects" rather than "New Data"
• Here you will see your newly created attribute "Variety".
• Select 'Variety'
• Give dataset a name "dataset2"
• Save the dataset
• link the schema attribute 'Variety' from dataset2 to the dataset1  
• Variety ID from dataset1 to Variety in dataset2
• Set the join behavior of dataset2 to secondary
• Right click the dataset > join behavior > secondary (inner join)

6. Now, add a matrix visualization and drop the below atributes:

• Variety (from dataset2) that will contain the description
• Currdatetime

7. You are done.  

8. Save the dossier

Now, ask the English and Dutch users to check the above created dossier. You will see the data changed according to the user language

English User

Dutch User