Adding support for multiple locales to members and attributes

You add support for multiple locales for members and attributes by dimension. It is not necessary that all dimensions in a dynamic cube support multiple locales. IBM® Cognos® Dynamic Cubes supports dynamic cube definitions in which only some dimensions have members with multiple locales.

Before you begin

If you are adding multiple locales to attributes, the data source must contain a column for each locale associated with the attribute. For example, the Great Outdoors Warehouse data source has a Product line attribute in the Products dimension. This attribute has columns named PRODUCT_LINE_EN, PRODUCT_LINE_FR, and so on, for each of the supported locales in the database.

Procedure

  1. In Project Explorer, click a dimension for which you want to add support for multiple locales.
  2. In the Properties tab, click the value for Multilingual Support and select By Column.

    You can now provide multilingual names for members and attributes.

  3. Perform the following steps for each member in the dimension that you want to give names in multiple languages.
    1. In Project Explorer, click a member in the dimension.
    2. In the Properties tab, click the value of the Name property.
      The supported locales for the project are displayed.
    3. For each supported locale, enter a name for the member in that language.
    4. You can add additional locales to the project by clicking the Add Language button.
  4. Perform the following steps for each attribute in the dimension that you want to give names in multiple languages.
    1. In Project Explorer, click an attribute in the dimension.
    2. In the Properties tab, click the value of the Name property.
      The supported locales for the project are displayed.
    3. For each supported locale, enter a name for the attribute in that language.
    4. You can add additional locales to the project by clicking the Add Language button.
    5. In the Properties tab, change the value of the Multilingual property to true.
    6. In the Properties tab, click the value of the Column Name property.
      The supported locales for the project are displayed.
    7. Expand the data source in Data Source explorer, and drag the column associated with each locale into the respective Column Name value.

      For example, the Great Outdoors Warehouse data source has a Product line attribute in the Products dimension. This attribute has columns named PRODUCT_LINE_EN, PRODUCT_LINE_FR, and so on, for each of the supported locales in the database. If you are enabling multilingual support for a dynamic cube that uses the Product line attribute in this database, you would drag the PRODUCT_LINE_EN column into the Column Name value for English, the PRODUCT_LINE_FR column into the Column Name value for French, and so on.