Translating dimension names

You can display dimension names in other languages by creating a TurboIntegrator process that creates the Caption attribute for all dimensions on your IBM® Cognos® TM1® server, then assigns Caption values for the dimension names you want to translate.

Before you begin

For complete details on using TurboIntegrator, see TM1 TurboIntegrator. For details on all TurboIntegrator functions, including DimensionAttrInsert and DimensionAttrPutS, see TM1 Reference.

About this task

You can create the Caption attribute as either an alias attribute or a string attribute. The benefit of creating the Caption attribute as an alias is that an alias attribute value can be passed as an argument to other TM1 functions, while string attribute values cannot.

Procedure

  1. Create a new TurboIntegrator process.
  2. On the Prolog tab, create the Caption attribute:

    To create Caption as an alias attribute, enter DimensionAttrInsert( '', 'Caption', 'A');

    To create Caption as a string attribute, enter DimensionAttrInsert( '', 'Caption', 'S');

    This creates a cube: }LocalizedDimensionAttributes dimensioned by }Dimensions, }Cultures, }DimensionAttributes

  3. For each dimension that you want to translate, insert a DimensionAttrPutS function for each language that you want to make available on your TM1 server.

    For example, if you want to display the Model dimension in French and Portuguese, your process would include the following functions:

    DimensionAttrPutS( 'Modèle', 'Model', 'Caption', 'fr' ); 
DimensionAttrPutS( 'Modelo', 'Model', 'Caption', 'pt' );
  4. Save and run the TurboIntegrator process.

Results

After the process successfully completes, the TM1 clients that support translation display any translated dimension names for the locale in which the client is running.