Query subject names displayed in different language

[saumil287]

Hi All,

I am having a doubt regarding names of query items which are displaying in different language which we select from active language.

The data values are coming from database (ie data source of gosales samples).

I want to know whether the query item names are stored in content store or datasource or it is internally converting the names using run locale function?

Thanks
saumil

[MFGF]

Hi,

The multilingial item names are included in the package definition. They need to be entered in FM (or imported from a translation text file). Each object (query subject, query item etc) has multiple names/descriptions etc in the content store (one for each language) and the language preference of the user dictates which is displayed.

The multilingual data values you see are stored as part of the report data. The model uses (typically) a macro based around the selected user language to decide which to retrieve - the modeller need to code this into the model.

Cognos 10 does not translate data - it uses these two mothods to present the appropriate names and data values :)

Cheers!

MF.

[saumil287]

Hi MFGF,

Thanks you very much for your reply.
So the data is not translated at run time. It fetches the info from content store.

So we should have a language data in our datasource database in order to display the reports in that language.

Thanks again
saumil287

[MFGF]

Hi,

So the data is not translated at run time. It fetches the info from content store.

Correct - but only if you have defined that info in the first place in Framework Manager. You need to add the relevant languages into the model definition, and this then means each object will have multiple name and description fields - one for each of your defined languages. You can manually type these in within FM, or (preferably) you can export a language translation file (Project > Languages > Export Translation File), edit this to add all the desired multilingual names, then import it back again.

So we should have a language data in our datasource database in order to display the reports in that language.

Correct again :) Typically you will have one of two scenarios:
a) Multiple columns for a descriptive item - one column for each language you need - eg you will have a Product Name EN column with the English product names in it and a Product Name FR with the French product names in it, etc. or
b) Multiple rows for each language, along with an identifying language column - eg your Products table will have a Language column containing values such as EN for English and FR for French, and each product will have multiple rows - one for each language.

Often you will need to use a parameter map to convert the language codes used by Cognos in the runlocale session parameter to the relevant language codes used in your data (or column headings). The macros you write will reference this to return the appropriate language code (eg converting fr-fr to FR) and then use this to grab the relevant data - either in a filter (in scenario b above) or by constructing the column name to retrieve (in scenario a above).

You can see examples of this in the sample great_outdoors_sales model - look at Database view > gosales > Product query subjects > PRODUCT_NAME_LOOKUP for an example of a query subject with a filter (scenario b) and look at Database view > gosales > Model query subjects (gosales) > Products for an example of query item names derived by a macro - eg Product line

Cheers!

MF.