reporting multilingual data using Cognos 8 reports

[800018940]

As discussed this is regarding reporting multilingual data using Cognos 8 repots.



Query database contains Unicode data (which is in encoded with special characters like & and # to recognize language data).



So when we reporting directly through reports data are displayed in Unicode itself.



Current Issue:



We are using hard code filters which are based on string (English), so unable to filter out data for Unicode values.



E.g. of Filters (based on English strings in present scenario) used are



TBL_MST_SECTION.Section='Willingness to recommend'

TBL_MST_SECTION.Section_text_vc='Overall Performance'

TBL_MST_QUESTION.Question_text_vc like 'Based on your overall%'



Please suggest on this regard ASAP as we are facing critical