COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: cognosun on 13 Feb 2012 08:03:58 PM

Title: Parameter maps - Multi-lingual data
Post by: cognosun on 13 Feb 2012 08:03:58 PM
I just have simple doubt in modeling.

People say that we can create multi-lingual reports using Parameter maps in Cognos.

But I doubt whether this statement is true or not ....

Because unless we have multi-lingual data ( one database table with one language data) within the database is it possible to create multi-lingual data in Cognos ?

I mean Cognos won't convert English into any other language right , unless different languages exist within the database ?
Title: Parameter maps - Multi-lingual data
Post by: MFGF on 14 Feb 2012 05:36:47 AM
Correct! :-) If you add multilingual names and descriptions to objects in Framework Manager, Cognos can display the relevant one based on a user's preferences, but it will not translate the data - you would need multilingual data in your database.

Regards,

MF.


Snet form my fumblefingers
iPhon 5 usig Tapatalk
Title: Re: Parameter maps - Multi-lingual data
Post by: blom0344 on 14 Feb 2012 12:25:56 PM
Translating limited set of codes (i.e.  codesets with a small number of distinct values ) is still possible using   # sq( $runLocale)# in case expressions.

Larger set of codes can be 'looked up' using (1)  lookup query subjects,  (2) proper joins ,  (3) a language column in the lookup to match Cognos output of # sq( $runLocale)# value for a given session

Random data can of course not be translated, you need it stored in the database..