COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: nishant.thakar on 15 Oct 2014 01:00:55 AM

Title: Cognos Transformer with Arabic Data
Post by: nishant.thakar on 15 Oct 2014 01:00:55 AM
Hi Gurus,
I am using Cognos Transformer 10.2.1 for building the cube.
The data being fetched is in Arabic.
Transformer is going into Unique Hierarchy path violation as the transformer is reading "?????" marks instead of Arabic language.
Please help!

Regards,
Nishant Thakar
Title: Re: Cognos Transformer with Arabic Data
Post by: Lynn on 15 Oct 2014 06:41:43 AM
I always thought that Transformer does not support unicode characters, but this document seems to imply otherwise. Perhaps it will help you.

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.1.1/com.ibm.swg.ba.cognos.ug_cogtr.10.1.1.doc/c_managelanguagelocale.html%23managelanguagelocale
Title: Re: Cognos Transformer with Arabic Data
Post by: nishant.thakar on 19 Oct 2014 02:15:07 AM
Thanks Lynn for the response.

Changing the OS locale helped me. :)
Title: Re: Cognos Transformer with Arabic Data
Post by: RangaReddy on 11 May 2016 07:17:06 AM
Hello Lynn/Nishant,

I am using Cognos Transformer 10.22 cube
I want display English and Arabic charters in analysis studio report.
(eg: XYZ(english)+ لأصلي نغ (Arabic)= XYZ لأصلي نغ   (result)

FM and report studio reports are showing Arabic characters but when I create the cube with transformer iam getting "??????????"  instead of Arabic letters.

How can I Do this.
Please help..