This discussion is archived
6 Replies Latest reply: Jan 22, 2013 8:30 AM by carlos.pereira RSS

OBIEE 11.1.1.6.2 Go Url pass filter with latin characters

carlos.pereira Newbie
Currently Being Moderated
Hi all,

I'm facing the following situation with obiee go url. It seems that obiee does not accept column names with latin characters (in this example the column name "Instalação"). The report simple ignores the filter and shows the output.
I tried with another column without special characters and filter works correctly.

Here is the example:
http://localhost:9704/analytics/saw.dll?Go&Path=/Shared/Temp/Instalações&NQUser=weblogic&NQPassword=welcome&Action=Navigate&P0=1&P1=eq&P2=Contador.Instalação&P3=1+TESTE

I also tryied the following with no sucess
http://localhost:9704/analytics/saw.dll?Go&Path=/Shared/Temp/Instalações&NQUser=weblogic&NQPassword=welcome&Action=Navigate&P0=1&P1=eq&P2=Contador."Instalação"&P3=1+TESTE

Can anyone help me?
  • 1. Re: OBIEE 11.1.1.6.2 Go Url pass filter with latin characters
    Srini VEERAVALLI Guru
    Currently Being Moderated
    The workaround is to append &charset=utf-8 to the URL

    BTW: whats your browser version? Other than IE7 without this should work.
    If helps pls mark as correct

    Edited by: Srini VEERAVALLI on Jan 18, 2013 11:48 AM
  • 2. Re: OBIEE 11.1.1.6.2 Go Url pass filter with latin characters
    carlos.pereira Newbie
    Currently Being Moderated
    Hi Srini ,

    Thanks for your replay, but it didn't resolve the issue.

    It continuous with the same behavior.

    Update: I'm testing in google chrome

    Edited by: carlos.pereira on Jan 18, 2013 6:37 PM
  • 3. Re: OBIEE 11.1.1.6.2 Go Url pass filter with latin characters
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Try by setting the below file changes to reflect as below

    In the file ORACLE_HOME/bifoundation/web/display/localecharactersetlists.xml
    <characterSet name="utf-8" />

    Once you done restart the presentation service

    Edited by: Srini VEERAVALLI on Jan 18, 2013 12:51 PM
  • 4. Re: OBIEE 11.1.1.6.2 Go Url pass filter with latin characters
    carlos.pereira Newbie
    Currently Being Moderated
    Hi Srini

    The file localechraractersetlist.xml already has the setting <characterSet name="utf-8" />

    My localecharactersetlists.xml looks like this.

    <?xml version="1.0" encoding="utf-8" ?>

    <!-- Preferred Character Sets for Languages and/or locales. -->

    <!-- Contents of this file are Copyright (C) 2001-2003 by Siebel Software, inc.
    and may not be in anyway used for any other product or purpose other than those
    of nQuire Software, inc. So there. -->

    <!-- Use the "language" attribute when referring to a group of locales (en, az, be)
    and the "locale" attribute when referring to a specific locale (en-US, fr-CA, cn-TW) -->

    <!-- The "title" attribute is for readability purposes only -->

    <!-- Character sets are listed in order of preference. -->

    <!-- Each character set label must be present in the "CharacterSetDefinitions.xml" file -->

    <sawl:localeCharacterSetLists xmlns:sawl="com.siebel.analytics.web.locale/v1" xmlns="com.siebel.analytics.web.locale/v1">

    <characterSetList name="locale:ar" title="Arabic">
         <characterSet name="utf-8" />
         <characterSet name="iso-8859-6" />
         <characterSet name="Windows-1256" />
         <characterSet name="ASMO-708" />
         <characterSet name="x-mac-arabic" />
    </characterSetList>

    <characterSetList name="locale:az" title="Azeri">
         <characterSet name="utf-8" />
         <characterSet name="iso-8859-5" />
         <characterSet name="Windows-1251" />
    </characterSetList>

    <characterSetList name="locale:be" title="Belarusian">
         <characterSet name="utf-8" />
         <characterSet name="iso-8859-5" />
         <characterSet name="Windows-1251" />
    </characterSetList>

    <characterSetList name="locale:bg" title="Bulgarian">
         <characterSet name="utf-8" />
         <characterSet name="iso-8859-5" />
         <characterSet name="Windows-1251" />
    </characterSetList>

    <characterSetList name="locale:ca" title="Catalan">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:cs" title="Czech">
         <characterSet name="utf-8" />
         <characterSet name="iso-8859-2" />
         <characterSet name="Windows-1250" />
    </characterSetList>

    <characterSetList name="locale:da" title="Danish">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
         <characterSet name="x-EBCDIC-DenmarkNorway" />
    </characterSetList>

    <characterSetList name="locale:de" title="German">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:el" title="Greek">
         <characterSet name="utf-8" />
         <characterSet name="iso-8859-7" />
         <characterSet name="Windows-1253" />
         <characterSet name="x-mac-greek" />
    </characterSetList>

    <characterSetList name="locale:en-us" title="English (United States)">
    <!--     <characterSet name="us-ascii" />-->
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" /> <!-- prefer the windows encoding as iso-8859-1 is less complete -->
         <characterSet name="iso-8859-1-ie" />
         <characterSet name="iso-8859-1" />
         <characterSet name="iso-8859-15" />
    </characterSetList>

    <characterSetList name="locale:en" title="English">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" /> <!-- prefer the windows encoding as iso-8859-1 is less complete -->
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
         <characterSet name="Windows-1252" />
    </characterSetList>

    <characterSetList name="locale:es" title="Spanish">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" /> <!-- prefer the windows encoding as iso-8859-1 is less complete -->
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:et" title="Estonian">
         <characterSet name="utf-8" />
         <characterSet name="iso-8859-4" />
         <characterSet name="Windows-1257" />
    </characterSetList>

    <characterSetList name="locale:eu" title="Basque">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:fa" title="Farsi">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1256" />
         <characterSet name="iso-8859-6" />
    </characterSetList>

    <characterSetList name="locale:fi" title="Finnish">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:fo" title="Faeroese">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:fr" title="French">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:hi" title="Hindi">
         <characterSet name="utf-8" />
    </characterSetList>

    <characterSetList name="locale:hr" title="Croatian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1250" />
         <characterSet name="iso-8859-2" />
    </characterSetList>

    <characterSetList name="locale:hu" title="Hungarian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1250" />
         <characterSet name="iso-8859-2" />
    </characterSetList>

    <characterSetList name="locale:hy" title="Armenian">
         <characterSet name="utf-8" />
    </characterSetList>

    <characterSetList name="locale:id" title="Indonesian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:is" title="Icelandic">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
         <characterSet name="x-mac-icelandic" />
    </characterSetList>

    <characterSetList name="locale:it" title="Italian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
    </characterSetList>


    <!-- Note that Analytics does not support the visually ordered Hebrew code page iso-8859-8 (but does support the logically ordered iso-8859-8-i). -->
    <characterSetList name="locale:he" title="Hebrew">




         <characterSet name="utf-8" />
         <characterSet name="iso-8859-8-i" />
         <characterSet name="x-mac-hebrew" />
    </characterSetList>

    <characterSetList name="locale:ja" title="Japanese">
         <characterSet name="utf-8" />
         <characterSet name="shift_jis" />
         <characterSet name="euc-jp" />
         <characterSet name="csISO2022JP" />
         <characterSet name="x-mac-japanese" />
         <characterSet name="x-EBCDIC-JapaneseAndJapaneseLatin" />
    <characterSet name="x-EBCDIC-JapaneseAndKana" />
    <characterSet name="x-EBCDIC-JapaneseAndUSCanada" />
    <characterSet name="x-EBCDIC-JapaneseKatakana" />
    </characterSetList>

    <characterSetList name="locale:ka" title="Georgian">
         <characterSet name="utf-8" />
    </characterSetList>

    <characterSetList name="locale:kk" title="Kazakh">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1251" />
         <characterSet name="iso-8859-5" />
    </characterSetList>

    <characterSetList name="locale:ko" title="Korean">
         <characterSet name="utf-8" />
         <characterSet name="euc-kr" />
         <characterSet name="ks_c_5601-1987" />
         <characterSet name="x-EBCDIC-KoreanAndKoreanExtended" />
         <characterSet name="x-EBCDIC-KoreanAndKoreanExtended" />
         <characterSet name="x-EBCDIC-KoreanExtended" />
         <characterSet name="x-mac-korean" />
         <characterSet name="Johab" />
    </characterSetList>

    <characterSetList name="locale:lt" title="Lithuanian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1257" />
         <characterSet name="iso-8859-4" />
    </characterSetList>

    <characterSetList name="locale:lv" title="Latvian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1257" />
         <characterSet name="iso-8859-4" />
    </characterSetList>

    <characterSetList name="locale:mk" title="Macedonian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1251" />
         <characterSet name="iso-8859-5" />
    </characterSetList>

    <characterSetList name="locale:mr" title="Marathi">
         <characterSet name="utf-8" />
    </characterSetList>

    <characterSetList name="locale:ms" title="Malay">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:nl" title="Dutch">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:no" title="Norwegian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:pl" title="Polish">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1250" />
         <characterSet name="iso-8859-2" />
    </characterSetList>

    <characterSetList name="locale:pt" title="Portuguese">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:pt-br" title="Portuguese (Brasil)">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:ro" title="Romanian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1250" />
         <characterSet name="iso-8859-2" />
    </characterSetList>

    <characterSetList name="locale:ru" title="Russian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1251" />
         <characterSet name="iso-8859-5" />
         <characterSet name="x-mac-cyrillic" />
    </characterSetList>

    <characterSetList name="locale:sa" title="Sanskrit">
         <characterSet name="utf-8" />
    </characterSetList>

    <characterSetList name="locale:sk" title="Slovak">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1250" />
         <characterSet name="iso-8859-2" />
    </characterSetList>

    <characterSetList name="locale:sl" title="Slovenian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1250" />
         <characterSet name="iso-8859-2" />
    </characterSetList>

    <characterSetList name="locale:sq" title="Albanian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1250" />
         <characterSet name="iso-8859-2" />
    </characterSetList>

    <characterSetList name="locale:sr" title="Serbian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1250" />
         <characterSet name="iso-8859-2" />
    </characterSetList>

    <characterSetList name="locale:sv" title="Swedish">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-15" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:sw" title="Swahili">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1252" />
         <characterSet name="iso-8859-1" />
    </characterSetList>

    <characterSetList name="locale:ta" title="Tamil">
         <characterSet name="utf-8" />
    </characterSetList>

    <characterSetList name="locale:th" title="Thai">
         <characterSet name="utf-8" />
         <characterSet name="x-EBCDIC-Thai" />
    </characterSetList>

    <characterSetList name="locale:tr" title="Turkish">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1254" />
         <characterSet name="iso-8859-3" />
         <characterSet name="iso-8859-9" />
         <characterSet name="x-mac-turkish" />
    </characterSetList>

    <characterSetList name="locale:tt" title="Tatar">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1251" />
         <characterSet name="iso-8859-5" />
    </characterSetList>

    <characterSetList name="locale:uk" title="Ukrainian">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1251" />
         <characterSet name="iso-8859-5" />
    </characterSetList>

    <characterSetList name="locale:ur" title="Urdu">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1256" />
         <characterSet name="iso-8859-6" />
    </characterSetList>

    <characterSetList name="locale:uz" title="Uzbek">
         <characterSet name="utf-8" />
         <characterSet name="Windows-1251" />
         <characterSet name="iso-8859-5" />
    </characterSetList>

    <characterSetList name="locale:vi" title="Vietnamese">
         <characterSet name="utf-8" />
    </characterSetList>

    <characterSetList name="locale:zh-tw" title="Chinese (Traditional / Taiwan)">
         <characterSet name="utf-8" />
         <characterSet name="big5" />
         <characterSet name="EUC-CN" />
         <characterSet name="gb2312" />
         <characterSet name="hz-gb-2312" />
         <characterSet name="x-mac-chinesetrad" />
    </characterSetList>

    <characterSetList name="locale:zh" title="Chinese (Simplified)">
         <characterSet name="utf-8" />
         <characterSet name="gb2312" />
         <characterSet name="hz-gb-2312" />
         <characterSet name="iso-2022-cn" />
         <characterSet name="EUC-CN" />
         <characterSet name="big5" />
         <characterSet name="x-mac-chinesesimp" />
    </characterSetList>

    </sawl:localeCharacterSetLists>
  • 5. Re: OBIEE 11.1.1.6.2 Go Url pass filter with latin characters
    Srini VEERAVALLI Guru
    Currently Being Moderated
    In the file <characterSet name="utf-8" /> tag suppose to be the first one, I've looked at your message, looks good.
    Not sure why its not working even appending &charset=utf-8 to the URL

    I've no idea... I'll update you if I come across with any suggestions.

    Pls update me if you get any solution for this.

    Thanks

    Edited by: Srini VEERAVALLI on Jan 19, 2013 11:01 AM
  • 6. Re: OBIEE 11.1.1.6.2 Go Url pass filter with latin characters
    carlos.pereira Newbie
    Currently Being Moderated
    Srini,

    I belive the problem was in google chrome, using firefox I can acess the reports through the url.

    Thanks a lot for your help.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points