Creating and Configuring a Project » Creating a production project » Enabling data internationalization for a project

Enabling data internationalization for a project

MicroStrategy supports the internationalization of your data into the languages required for your users. This allows translated data from your data source to be integrated into a MicroStrategy project. This data can then be displayed in the various languages that reflect a user’s language preferences.

More specifically, data internationalization allows attribute element data to be displayed in various languages. For example, the Month of Year attribute element data is supplied in both English and German, as shown in the reports below.

The attribute elements for the Month of Year attribute can be supplied in multiple languages through data internationalization. For example, the January, February, and March attribute elements are displayed as Januar, Februar, and März for users that are defined to view data in German.

Data internationalization is different than metadata internationalization. Metadata internationalization allows various MicroStrategy metadata object names, descriptions, and other strings to be supplied in various languages. For example, in a project you can provide the names of attributes, metrics, folders, and other objects in multiple languages. For information on how to provide translated strings for metadata objects such as attributes, metrics, folders and so on, see the Supplemental Reference for System Administration.

MicroStrategy supports data internationalization through two techniques. You can provide translated data through:

the use of extra tables and columns
separate databases to store translated data

For a description of these two methods, see Supporting data internationalization.

If you plan to use internationalized data with your attributes, you should define how data internationalization is enabled before creating attributes. By defining how internationalized data is represented in your data source, Architect, the Attribute Creation Wizard, and the Fact Creation Wizard can recognize internationalized data when automatically creating attributes. This can save you the time that would be required to go back and modify attributes to recognize and use the internationalized data.

To support one of these data internationalization methods, follow one of the procedures described below:

Enabling data internationalization through SQL queries
Enabling data internationalization through SQL queries