6 Replies Latest reply: Jan 22, 2013 10:30 AM by carlos.pereira RSS

    OBIEE 11.1.1.6.2 Go Url pass filter with latin characters

    carlos.pereira
      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
          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
            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
              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
                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
                  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
                    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.