Localizing cube names

You localize cube names 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 localize.

Before you begin

For complete details on using TurboIntegrator, see the IBM Cognos TurboIntegrator Guide. For details on all TurboIntegrator functions, including CubeAttrInsert and CubeAttrPutS, see the IBM Cognos TM1 Reference Guide.

Procedure

  1. Create a new TurboIntegrator process.
  2. On the Prolog tab, enter the following function:

    CubeAttrInsert( '', 'Caption', 'S');

    This function creates the Caption attribute as a string attribute for the cubes on your TM1 server. Alternatively, you can create the Caption attribute as an alias attribute type. 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.

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

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

    For example, if you want to localize both the Sales and Price cubes into 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 execute the TurboIntegrator process.

Results

After the process successfully executes, the TM1 clients that support localization display any localized cube names for the locale in which the client is running.