Translating cube names

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

1. Create a new TurboIntegrator process.
2. On the Prolog tab, create the Caption attribute.
   Note: When defining the Caption attributes, it is advantageous to define the Caption attribute as an Alias type. In websheets, dimensions can be set to display only an alias. In addition, when defining a SUBNM for display in a web sheet, it can take only an alias as an argument. Similarly, in IBM Planning Analytics for Microsoft Excel, SUBNM takes an alias as an argument.

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

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

   This creates a cube: }LocalizedCubeAttributes dimensioned by }Cubes, }Cultures, }CubeAttributes.

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

   For example, if you want to display the Sales cube and Price cube in French and German, your process would include the following four functions:

   CubeAttrPutS( 'Ventes', 'Sales', 'Caption', 'fr' ); 
   CubeAttrPutS( 'Vertrieb', 'Sales', 'Caption', 'de' ); 
   CubeAttrPutS( 'Prix', 'Price', 'Caption', 'fr' ); 
   CubeAttrPutS( 'Preis', 'Price', 'Caption', 'de' );

4. Save and run the TurboIntegrator process.