Manage Translations in Framework Manager

Managing translations in Framework Manager can be a bit of a hustle. This post describes a handy way of keeping track of your translations and avoiding frustrating rework.

The solution is based on a simple Excel file that uses a master translation list that is applied on whatever part of the Framework Models that has to be translated using VLOOKUP.

Using translations in Framework Manager has a couple of challenges attached to it:

  • How to stay consistent in the model?
  • How to make sure that duplicate items are translated in the same way throughout the model?
  • How to avoid rework?
  • How to avoid manually typing all the translation in Framework Manager?
  • How to keep track of what translations are used for what items?

The solution is to use an Excel file to keep track of all this and manage an item master translation list that is applied to any part of the model.

Step 1: Translation File Setup

The first step is to create an item master translation list containing all the items of the model with their associated translation.

  • Export all technical items from the Framework Manager project to a language file.

IBM Cognos Framework Manager Languages

 

  • Download the Framework Manager Translation File (FrameworkManagerTranslationFile.xlsx).
  • Paste the technical items from the export language file in column A in sheet “Lookup Sheet”. 

IBM Cognos Framework Manager Languages

  • Fill column B in the sheet “Lookup Sheet” with the business names for each technical name.

IBM Cognos Framework Manager Languages

Step 2: Using the Translation File for a Business Language

The next step is to take a part of the Framework Model that has to be translated. This process can be repeated several times for different parts of the model or even for different models. Just make sure that a single language is used and kept with all the technical item names. As such it is always possible to revert or update parts of the model when changes are introduced.

  • Create a business language in your Framework Manager project.

IBM Cognos Framework Manager Languages

  • Export the items from a certain part of the Framework Manager model with only the language that holds the technical item names. 

IBM Cognos Framework Manager Languages

  • Paste the technical item names in column A of the sheet “Import I”, including the language header (e.g. “en”) .

IBM Cognos Framework Manager Languages

  • Extend the VLOOKUP formula in column B in sheet “Import I” to cover all the items in column A. 

IBM Cognos Framework Manager Languages

  • Rename column B in sheet “Import I” to the language name of the Business language. 

IBM Cognos Framework Manager Languages

  • Save the sheet “Import I” as a *.txt file (make sure it is as unicode.txt). 

11 IBM Cognos Framework Manager Languages

  • Import the sheet in the Framework Manager project and perform the correct mapping. 

IBM Cognos Framework Manager Languages

  • That should do it.

IBM Cognos Framework Manager Languages

 

IBM Cognos Framework Manager Languages

Cognos Service