Localizing Intelligent Cubes in multiple languages

If your MicroStrategy project supports the localization of information into multiple languages, you can also support this localization to provide Intelligent Cubes in multiple languages.

When an Intelligent Cube is defined to support a language, data is available for the Intelligent Cube in that language. When a user logs in to MicroStrategy in the locale for that language and creates or views a report that accesses the Intelligent Cube, all data that has been localized is returned.

For example, a report is connected to an Intelligent Cube that is defined to include information for the English and Italian locales. This report connected to the Intelligent Cube is executed by a user with an English locale. This same report is also executed by a user with an Italian locale. The same report returns data that matches the user's locale. This is because the Intelligent Cube has been defined include localized data.

Localizing an Intelligent Cube does not localize any data, it only returns data that has already been configured in a MicroStrategy project as part of a localization solution. For information on defining localization rules for your MicroStrategy projects, see the Project Design Help.

Providing localized data causes the Intelligent Cube size to be larger than if it supported only a single locale. However, providing localized data in Intelligent Cubes is necessary if users expect reports that return Intelligent Cube data to return localized data to reflect their locale.

The steps below let you define Intelligent Cubes to support various languages.

Prerequisites

• An Intelligent Cube has been created.

• The project for the Intelligent Cube has been configured to support multiple languages. For information on localizing projects, see the Project Design Help.

• You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. This privilege is part of OLAP Services.

To support multiple languages in an Intelligent Cube

1. In MicroStrategy Developer, browse to an Intelligent Cube.

2. Right-click the Intelligent Cube and select Edit. The Intelligent Cube opens in the Report Editor.

3. From the Data menu, select Configure Intelligent Cube. The Intelligent Cube Options dialog box opens.

4. From the Categories list, expand Options, and then select Data Languages.

5. Select from the following localization options:

   • Use project default data language (Default): Select this option to provide data only in the default language for the project. The default language for the project is highlighted in blue.

   • All project data languages: Select this option to provide data for the languages available for the project.

   • Select specific languages: Select this option to select from all languages available for the project. Data is provided for the languages you select.

   • All of these options are based on the language options defined for the project, which can be modified from the Project Configuration Editor. For information on localizing projects, see the Project Design Guide.

6. Click OK. The Intelligent Cube Options dialog box closes and you are returned to the Intelligent Cube.

7. Click Save and Close to save your changes and close the Report Editor.

8. To make your changes available for reports accessing the Intelligent Cube, you must publish the Intelligent Cube, which is described in Publishing Intelligent Cubes.