Enabling or Disabling Languages in the Project to Support DI

For languages that are stored in your data warehouse to be available for use in MicroStrategy, you must configure the project to support those languages.

You can also add a custom language to the list of languages available to be enabled for data internationalization. For steps to add a custom language to the project, see Adding or Removing a Language in the System.

Enabling Languages for Data Internationalization

After translated data has been stored, you must configure the project to establish which languages will be supported for data internationalization (DI). You must perform this procedure whether you store translated data using a SQL-based DI model or a connection-based DI model.

To Enable Data Internationalization Languages in a Project

Log in to a project as a user with administrative privileges.
Right-click the project and select Project Configuration.
On the left side of the Project Configuration Editor, expand Language, then select Data.
Select the Enable data internationalization check box.
Select the DI model that you are using. For details, see Storing Translated Data: Data Internationalization Models.

For a SQL-based DI model, select SQL based.
For a connection-based DI model, select Connection mapping based.

Click Add.
Languages displayed in bold blue are those languages that have been enabled for the project to support translated metadata objects, if any. This list is displayed as a starting point for the set of languages you can choose to enable for supporting data internationalization.

To display all available languages, or if no metadata languages are displayed, clear the Display metadata languages only check box.
To add a new language, make sure the Display metadata languages only check box is cleared, and then click New. For steps to create a custom language, see Adding or Removing a Language in the System.

Select the check box next to any language or languages that you want to enable for this project.

If no languages are selected to be enabled to support data internationalization, then data internationalization is treated by the system as disabled.
Click OK.
In the Default column, select one language to be the default language for data internationalization in the project. This selection does not have any impact on the project or how languages are supported for data internationalization. Unlike the MDI default language, this DI default language can be changed at any time.
If no default DI language is selected, data internationalization is treated by the system as disabled.
For each language you have enabled, define the column/table naming pattern or the connection-mapped warehouse, depending on which DI model you are using (for information on DI models and on naming patterns, see Storing Translated Data: Data Internationalization Models):

SQL-based DI model: If you selected the SQL-based DI model above, click the Column Pattern and Table Pattern columns next to one of the languages you will support. Type the column or table prefix or suffix and click OK. For examples, click Help.
Some languages may have the same suffix - for example, English US and English UK. You can also specify a NULL suffix.

Click OK.
Disconnect and reconnect to the project source so that your changes take effect. To do this, right-click the project source, select Disconnect from Project Source, then repeat this and select Connect to Project Source.

Disabling a Language for Data Internationalization

You can use the steps below to disable a language for a project. When a language has been disabled in a project, that language is no longer available for users to select as a language preference, and the language cannot be seen in any translation-related interfaces such as an object's default language in its Properties - International dialog box. Any translations for the disabled language are not removed from the data warehouse with these steps.

If a user has selected the language as a language preference, the preference will no longer be in effect once the language is disabled. The project's default language will take effect.

If you remove the language currently set as the default data internationalization language, the system automatically selects the first language in the list of remaining enabled languages to set the new default language. This new default data internationalization language should not have any impact on your project.

If you disable all languages for data internationalization (DI), the system treats DI as disabled. Likewise, if you do not have a default language set for DI, the system treats DI as disabled.

To Disable Data Internationalization Languages in a Project

Log in to a project as a user with administrative privileges.
Right-click the project and select Project Configuration.
On the left side of the Project Configuration Editor, expand Language, then select Data.
On the right side, under Selected Languages, clear the check box for the language that you want to disable for the project.
Click OK.
Perform the following steps depending on how your project is affected:

Empty any caches or Intelligent Cubes containing content in the disabled DI language.
Language disabling will only affect MDX cubes and regular reports and documents if an attribute form description in the disabled language exists in the cube or report. If this is true, the cube, report, or document cannot be published or used. The cube, report, or document designer must remove attribute forms in the disabled language before the cube/report/document can be used again.

Disconnect and reconnect to the project source so that your changes take effect. To do this, right-click the project source, select Disconnect from Project Source, then repeat this and select Connect to Project Source.