How to Communicate in Multiple Languages with MicroStrategy

When implementing a unified Business Intelligence (BI) solution for a multinational company, there might be language barriers that arise. To tackle this situation, we can use the multi-lingual feature of MicroStrategy and provide translations from a primary language to any number of secondary languages, empowering a single environment to communicate in many languages.

MicroStrategy Languages

MicroStrategy out-of-the-box comes with a choice of languages that can be used for the interface translation. Here is how to provide translations for the project objects.

Prerequisites

  • Administrative access to the project
  • Access to the Intelligence Server to be restarted
  • Object Manager installed
  • Access to the database to store translations

Procedure

Back-up original project metadata

  1. Back-up original project’s metadata to reduce risk in case of corruption.

Make languages available in the project to be used for metadata translations

  1. To provide MicroStrategy object translations we need to make changes from MicroStrategy Desktop environment. Right-click on the project and go to: Project Configuration → Language → Metadata

MicroStrategy Languages

Add whichever additional languages are necessary by clicking the Add button.

MicroStrategy Languages

Make changes to the user language preferences

  1. Go to: Project Configuration Language User Preferences
    Click Modify

MicroStrategy Languages
MicroStrategy Languages

Make the metadata language selections for the appropriate users for their respective languages.

Update the languages for the project

  1. Go to Project Configuration Update Translations

    Click Update to save the changes (this can take a few minutes).

    MicroStrategy Languages
    MicroStrategy Languages

  1. Restart the Intelligence Server.

Export language translations to a database

  1. Open: Start Menu MicroStrategy Object Manager MicroStrategy Repository Translation Wizard
  2. Click Next
  3. Choose the translation action Export Translations, enter administrative credentials, and click Next


  1. Choose the project, choose the reference language (usually the default project language, in our case English)
  2. Check the languages you want to provide translations for and click Next

  1. Next, choose the objects for which you want to provide/edit translations. (You can choose all the objects in the project or only those for which you want to provide the translations), click Next

  1. Select (or create) a new database to store the translations, and enter the login credentials.
  2. Click Next and Finish, to export the translations extract into the database

Import language translations from database

  1. Go-to the translations table in the database that is exported from MicroStrategy
  2. Use an SQL Manager Studio or Excel export/import to provide translation for each of the object property.

The REFTRANSLATION column has the English words for which you can provide the other language translations in the TRANSLATION column.

  1. Open: MicroStrategy Object Manager MicroStrategy Repository Translation Wizard
  2. Click Next
  3. Choose the translation action Import Translations, enter administrative credentials, and click Next

  1. Choose the data source for the translations to be imported and connect
  2. Select the table from which the translations are to be imported
  3. Click Next and Finish to import the language translations into the MicroStrategy project
  4. Restart the Intelligence Server.
  5. When the users in Step 3 logs into the environment web or desktop, they see the project objects with the corresponding translations.

Hence by using MicroStrategy’s interface language choice (settings in the User Preference on web and Project Preference on desktop) and the above method for object translations, we can make the MicroStrategy environment a truly multi-lingual system.

There’s more to explore at Smartbridge.com!

Sign up to be notified when we publish articles, news, videos and more!