How to adjust a Cognos Analytics 11 Framework Manager model to enable multi-language support using a calculation query item.

Answer

Steps on how to create a parameter map and multi-language calculation using the ‘great_outdoors_sales.cpf’ Framework Manager model in English and Spanish are as follows:

Opening the Framework Manager model

1. Open Cognos Analytics 11 Framework Manager and select ‘Open a project…’.

2. Import the ‘great_outdoors_sales.cpf’ model.

Creating the ‘Language_Lookup’ parameter map

1. In the Project Viewer pane, right-click on ‘Parameter Maps’. Click ‘Create’ and select ‘Parameter Map’.

2. Enter ‘Language_Lookup’ as the name of the parameter map and then click ‘Next’.

3. Select ‘New Key’. Under the ‘Key’ column, enter ‘en’. Under the ‘Value’ column, enter ‘EN’.

4. Select ‘New Key’ again. Under the ‘Key’ column, enter ‘es’. Under the ‘Value’ column, enter ‘ES’. Then click ‘Finish’ to complete.

Establishing the multi-language support calculation

1. Within the ‘go_sales’ package of the Project Viewer pane, navigate to the ‘Database view > gosales > Product query subjects’. Right-click on the ‘PRODUCT_LINE’ query subject and select ‘Edit Definition…’.

2. Click on the ‘Calculations’ tab and select ‘Add’ at the bottom to create a new calculation.

3. Provide the calculation with a name such as ‘MLproductLine’ and enter the following phrase or similar into ‘Expression definition: ’: #'[gosales].[PRODUCT_LINE].[PRODUCT_LINE_'+$Language_Lookup{$runLocale}+']'#. Click the blue tick icon above the calculation name to validate the expression.

Testing both languages in Framework Manager

1. Next to the blue tick icon, click the blue arrow to test the data in English. Upon clicking, you should see all the data for ‘MLproductLine’ returning in English before clicking ‘OK’ and ‘OK’ again to close the tabs.

2. To test for Spanish, click the ‘Project’ menu before selecting ‘Session Parameters…’. Click on the ‘Override Value’ cell for ‘runLocale’, type ‘es’ and then click ‘OK.

3. Return to the ‘PRODUCT_LINE’ query subject and select ‘Edit Definition…’ again. Click on the ‘Calculations’ tab and select the ‘MLproductLine’ calculation that you created previously. Proceed to click the blue arrow at the top and the data should now appear in Spanish.