COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: UseCog on 12 Feb 2009 04:42:50 AM

Title: how to setup multilingual column headers using same model in FRAME WORK MANAGER
Post by: UseCog on 12 Feb 2009 04:42:50 AM
Hi gurus,

Can anybody tell me the steps for creating a report whose headers can be shown in the langauage as per the locales. eg:- if a french user opens the reports he needs to see the column headers in french and if a spanish user opens the report he needs to see it in spanish.

Any helps and suggestions appreciated

thanks,
ug
Title: Re: how to setup multilingual column headers using same model in FRAME WORK MANAGER
Post by: UseCog on 13 Feb 2009 08:44:21 AM
I have got the solution using language variables in RS. Thanks
Title: Re: how to setup multilingual column headers using same model in FRAME WORK MANAGER
Post by: TEVAMANA on 27 Feb 2009 01:22:57 PM
Hi,

You can use a macro if your column names are like this: LABEL_FR, LABEL_EN

You create in your FM a column like this LABEL_#use session parameter#

Like that it will be dynamic in Report Studio, you can find an example in the documentation.

Regards
Title: Re: how to setup multilingual column headers using same model in FRAME WORK MANAGER
Post by: UseCog on 28 Feb 2009 08:21:18 AM
Thanks Tevamana.
Title: Re: how to setup multilingual column headers using same model in FRAME WORK MANAGER
Post by: nivas_palle on 10 Mar 2009 06:05:45 AM
Hi,

For this you can achive it using parametermaps..(lookups like to have key and value to it).
and use macro to get the session parameters(it helps you to get the user locale details..i mean if french user loggoed in..locale language gives you French..).
Create a query subject out of it.. use it in report studio.. you can achive this.


Tell me if i am wrong.!!
Title: Re: how to setup multilingual column headers using same model in FRAME WORK MANAGER
Post by: UseCog on 10 Mar 2009 10:26:04 AM
i want to show the headers multi lingually. So i think language variable is the best way to achieve this.