Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  French accents are not displayed in Report Studio

    Posted Wed December 09, 2020 03:59 PM
    Hi,

    I'am using IBM Cognos Analytics 11.0.7 with Oracle DB.

    When I type in a query calculation an accented character, this character is not displayed.

    For instance: 
    Example of a query calculation with some accented characters
    In the example above:
    The accented characters typed in Report Studio are not displayed.
    The accented characters from the DB are properly displayed.


    The query executed directly in Oracle retrieves all accented characters :

    How display the accented characters when generating the report ?

    Thanks in advance !

    Regards,




    ------------------------------
    David Jacquot
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: French accents are not displayed in Report Studio

    Posted Thu December 10, 2020 12:28 PM
    Edited by System Admin Fri January 20, 2023 04:10 PM

    Salut David,

    The expression is part of the report specification.  The report spec is supposed to be encoded with UTF-8. For example, the character é would be represented as 2 hex bytes 0xC3 x0A9 in the report spec.  A colleague from our Report team just tried creating a query expression using [Product line] || 'é' and it worked.

    If that does not help you find the root of the issue, and if the changing your product language and content language to French does not resolve this, we would recommend opening a case with IBM Support to see if there are other variables that might be influencing to what you're seeing.

    J'espère que cela vous a aidé à résoudre votre problème,

    // Brennan

    ​
    (Thank you to @PAUL Labossière for the guidance about the report spec)

    ------------------------------
    Brennan Fox

    Product Quality @ IBM Cognos Analytics
    ------------------------------

    Original Message


  • 3.  RE: French accents are not displayed in Report Studio

    Posted Thu December 10, 2020 12:57 PM
    Salut Brennan,

    Merci de votre aide !

    Originaly, the product language and content language is set to French. I changed them to English to be more understable by English folks ^^
    We will consider opening a case with IBM support and I wil post here the result.

    Merci encore,

    ------------------------------
    David Jacquot
    ------------------------------

    Original Message


  • 4.  RE: French accents are not displayed in Report Studio
    Best Answer

    Posted Sun December 13, 2020 01:13 PM
    Edited by System Admin Fri January 20, 2023 04:50 PM
    Hi all,

    I have finally found the solution.

    With the Windows Registry Editor, I set in the NLS_LANG in the registry of the WIndows server where is hosted Cognos.
    A NLS_LANG subkey was already set on HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE and on HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraClient12Home1_32bit.
    However, a new Oracle client was installed on the server and the related registry entry (HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraClient12Home2_32bit])had not subkey for NLS_LANG.

    I set FRENCH_FRANCE.WE8MSWIN1252 for NLS_LANG : This is now working like magic ^^

    David

    ------------------------------
    David Jacquot
    ------------------------------

    Original Message