COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gpreddy1986 on 10 Aug 2010 05:32:09 AM

Title: create reports in diiffernt languages
Post by: gpreddy1986 on 10 Aug 2010 05:32:09 AM
Hi friends
  How can we create reports in differents lanuages from the single package..........
thanks
Title: Re: create reports in diiffernt languages
Post by: CognosPaul on 10 Aug 2010 05:41:23 AM
Look up language variable for elements in RS. For changing the data in the report itself read up here (http://www.element61.be/e/resourc-detail.asp?ResourceId=7).
Title: Re: create reports in diiffernt languages
Post by: blom0344 on 10 Aug 2010 07:01:59 AM
You should distinguish between data and metadata. We build our new framework models in a specific design language and add required languages to the model making sure that each query subject and item receives it's proper multilingual name. No lookups or macro's are needed for that part, it is standard C8 feature.
For data we use 1 generic lookup table (added to the source database) and a database function to be able to translate sets of codes from the data into multilingual descriptions. We do not use parameter maps nor macro's , but we find our solution (thanks again, Jeroen) works perfectly.

In reports we use report expressions based on the locale() setting and language variables. This is not ideal, since it means an awful lot of work.

Ultimately we publish a package making sure we either omit or add languages to the specific package. In connection only one object is visible at any time. At run-time the proper language version of the package is loaded..