IBM Business Analytics Proven Practices: IBM Cognos TM1 - Multilingual Cubes Using Cube Views

Product(s): IBM Cognos TM1; Area of Interest: Modeling

This document will demonstrate how to utilize aliases, subsets, and TM1 Cube Views to display TM1 cubes in a different language.

Steve Jung, Software Developer, IBM

Steve Jung is a Software Developer in IBM Global Business Solution Center (GBSC). He is the lead architect of the BAO Signature Solution – CFO Dashboard. He is also an IBM Cognos TM1 Certified Data Analysis Specialist and Developer.



Chun Liu, Application Architect, IBM

Chun Liu is an Application Architect in IBM Global Business Solution Center (GBSC). He has more than eight years experience for IT application development and architecture. Chun has participated in many Business Intelligence and Data Warehouse project engagements and deliveries to build and harvest reusable assets enabling more Business Analytics and Optimization opportunities for IBM. He is also an IBM Certified Associate Architect and IBM Cognos TM1 Certified Data Analysis.



26 May 2014

Introduction

Purpose of Document

This document will demonstrate how to utilize aliases, subsets, and TM1 Cube Views to display TM1 cubes in a different language.

Applicability

This document was written and tested against IBM Cognos TM1 9.5.2, 10.1.1, and 10.2. The final test was done on 10.2 and uses the 10.2 GO_New_Sales samples that ship with the product. Please refer to the product documentation on how to setup the samples should you wish to follow along with the steps found in this document.

Assumptions

This document assumes readers have experience with IBM Cognos TM1 and understand basic TM1 operations such as how to create a TM1 Cube View and how to add new element attributes.


Overview

For TM1 developers, there is often a need after a model is built to display the cube in another language. With the current product design, TM1 does not provide alias support for many of its objects, including Cube Views and Dimension Subsets. For the objects that do have alias support, TM1 lacks a mechanism that could quickly switch the object alias from one to another.

This document will demonstrate how to utilize aliases, subsets, and TM1 Cube Views to display TM1 content in a different language. The following is a step by step guide on how to implement this technique.


Steps required to create a TM1 Cube View in a desired language

The steps required to create a TM1 Cube View in a desired language can be divided into four sections:

  • Adding aliases to cube dimensions
  • Adding aliases to dimension elements
  • Creating new dimension subsets
  • Creating a new cube view

This chapter describes the steps of each section in detail.

Section 1 - Add aliases to cube dimensions

This section describes how to add aliases to the dimensions in a cube.

  1. In TM1 Architect/Perspective Server Explorer, expand the cube you wish to add a new language to, right click on Dimensions, and then click Edit Attributes. In this example, we will work with the Product cube.
    Figure 1: Dimensions right-click menu with Edit Attributes option highlighted
    Figure 1: Dimensions right-click menu with Edit Attributes option highlighted
    The Attributes Editor window opens.
  2. Inside the Attributes Editor window, right-click any of the column headers, click Add New Attribute, select Alias, and then in the Name box, type the name you would like for the alias. In this case, we will use French.
  3. Click OK, and then click OK again to the warning dialog. The Attributes Editor now displays the new alias column to the right containing default values for each dimension. If necessary, resize the window or scroll to the right to see the new column.
    Figure 2: Attributes Editor showing new French (Alias) column just created
    Figure 2: Attributes Editor showing new French (Alias) column just created
    The new attribute values will need to be translated for each dimension in the cube you wish to display in another language. For this example, we will simply translate the three dimensions found in the Product cube. In this case we will translate Products, Budget Version, and Price and Cost to Produits, Version du budget, and Prix ​​et coûts respectively.
  4. Click OK.

Section 2 - Add aliases to dimension elements

This section describes how to add aliases to the elements inside each cube dimension.

  1. In TM1 Architect/Perspective Server Explorer, expand the cube you are interested in, and then expand Dimensions.
  2. Right-click on a dimension, in this case Products, and then click Edit Element Attributes…
    Figure 3 - Dimension right-click menu with Edit Element Attributes option highlighted
    Figure 3 - Dimension right-click menu with Edit Element Attributes option highlighted
  3. In the Attributes Editor window, right-click any of the column headers, click Add New Attribute, select Alias, and then in the Name box, type the name you would like for the alias. In this case, we will use French.
  4. Click OK, and then click OK again to the warning dialog. The Attributes Editor now displays the new alias column to the right containing default values for each dimension. If necessary, resize the window or scroll to the right to see the new column.
    Figure 4 - Attributes Editor showing new French (Alias) column just created
    Figure 4 - Attributes Editor showing new French (Alias) column just created
    The new attribute values will need to be translated for each element in the dimension.
  5. Click OK.
  6. Repeat the process for each dimension in the cube.

Section 3 - Create new dimension subsets

This section describes how to create new dimension subsets to display dimension elements in a particular alias.

For each cube dimension, perform the following steps to create a new dimension subset:

  1. Under the desired cube, right-click the dimension, in this case Products, and then click Insert New Subset…
    Figure 5 – Dimension right-click menu with Insert New Subset option highlighted
    Figure 5 – Dimension right-click menu with Insert New Subset option highlighted
  2. In the Subset Editor window, turn on alias by clicking the Use Aliases button, and then select French (the new alias just created) from the drop down list.
    Figure 6 – Subset Editor Window showing Use Alias feature currently on and new French alias selected from drop down list
    Figure 6 – Subset Editor Window showing Use Alias feature currently on and new French alias selected from drop down list
  3. From the Subset menu, save the subset with the name Produits. If you would like this subset to be public, deselect the Private check box.
    Figure 7 – TM1 Save Subset dialog with Produit subset entered as the new subset name
    Figure 7 – TM1 Save Subset dialog with Produit subset entered as the new subset name
  4. Click OK.
  5. Repeat these steps for the Budget Version and Price and Cost dimensions in the cube naming them Version du budget and Prix et coûts respectively.

Section 4 - Create a new TM1 Cube View

This section describes how to create a new TM1 Cube View based on the dimension subsets created in Section 3 - Create new dimension subsets.

  1. Right-click on the cube and click Browse. In this example, we are using the Product cube. The Cube Viewer window opens.
  2. For each dimension in the cube view, double-click on the context dimensions and single-click the crosstab dimensions to bring up their Subset Editor. Change the subset currently in use to the respective subsets created in Section 3 - Create new dimension subsets. For example, for Products, select the Produits subset as shown in Figure 8.
    Figure 8 – Subset Editor window with the Produits subset selected in the dropdown list
    Figure 8 – Subset Editor window with the Produits subset selected in the dropdown list
  3. Click OK, and then click the Recalculate button or the Automatically Recalculate button (if you want the view automatically recalculated when the view changes) on the toolbar if you wish to see values in the crosstab.
  4. From the File menu, click Save and save the view as Produit and deselect the Private check box if you wish the view to be public.
  5. Click OK. A TM1 Cube View of the Product cube with everything displayed in the French alias is now created as shown in Figure 9.
    Figure 9 - TM1 Cube View displayed in the French aliases created earlier
    Figure 9 - TM1 Cube View displayed in the French aliases created earlier
  6. Close the Cube Viewer.

Show only the translated TM1 Cube View (Optional)

If you only wanted to show users the cube views that have everything displayed in the right alias (French aliases in our example), you could allow users to connect to the TM1 data server only through TM1 Web and publish only the translated cube views into the Application folder(s). In the TM1 Web configuration you can hide all TM1 Cube Views and show only the Application folder(s).

This optional section describes how to implement this technique.

  1. In the TM1 Web configuration file, make the following change to hide the Views node in the navigation pane. In versions prior to 10.2, this change is done in the Web.config file located in the TM1 Web installation directory. For the 10.2 release, edit the tm1web_config.xml file located under <TM1 install directory>\webapps\tm1web\WEB-INF\configuration.
    <!--NavTreeDisplayServerView: Y/N - Wether to display
    "Server View" node in navigation tree -->
    <add key="NavTreeDisplayServerView" value="N" />
  2. Recycle the TM1 Admin service to pick up the change. The IBM Cognos TM1 Web user interface will no longer display the Views node.
    Figure 10 - IBM Cognos TM1 Web UI only showing the Applications node
    Figure 10 - IBM Cognos TM1 Web UI only showing the Applications node
  3. In TM1 Architect/Perspective Server Explorer, right-click on Applications, and then click Create New Application.
    Figure 11 – Applications right-click menu showing Create New Application highlighted
    Figure 11 – Applications right-click menu showing Create New Application highlighted
  4. Name the new application folder Français (so that users know all the views in this folder will be in French), and then drag and drop the cube view created in Section 4 - Create a new TM1 Cube View, in this case Produit, into the application folder.
    Figure 12 – Produit applications folder containing the Produit view
    Figure 12 – Produit applications folder containing the Produit view

Now in TM1 Web, users will only see the cube view with everything displayed in French as shown in Figure 13.

Figure 13 – TM1 Web showing the Produit cube view with all data in French
Figure 13 – TM1 Web showing the Produit cube view with all data in French

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Big data and analytics on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Big data and analytics
ArticleID=972215
ArticleTitle=IBM Business Analytics Proven Practices: IBM Cognos TM1 - Multilingual Cubes Using Cube Views
publish-date=05262014