20 November, 2017

Changing date format in OBIEE 12c portal

There are many ways how to set default date format in OBIEE portal, some of those options are:
  • Manually in "My Account" option window for each user
  • With USERLOCALE system session variable in RPD file (Init block)
For me, best way is to change this options with little "hack". In the OBIEE installation folder locate $FMW_HOME/bi/bifoundation/web/display/localemappings.xml file. Edit it with one of preffered text editor.

In the file, find string specified below:
<when matches="*"><localeDefinition name="en-gb"/></when>

If you want that all BI users has locale definition in italian, your string must look like: 

 <when matches="*"><localeDefinition name="it-it"/></when>After changing this value, save your file and restart all BI services.

Supported locales


Country
(ISO 3166)
Language Tag
Albanian (sq)Albania (AL)sq-AL
Arabic (ar)Algeria (DZ)ar-DZ
Arabic (ar)Bahrain (BH)ar-BH
Arabic (ar)Egypt (EG)ar-EG
Arabic (ar)Iraq (IQ)ar-IQ
Arabic (ar)Jordan (JO)ar-JO
Arabic (ar)Kuwait (KW)ar-KW
Arabic (ar)Lebanon (LB)ar-LB
Arabic (ar)Libya (LY)ar-LY
Arabic (ar)Morocco (MA)ar-MA
Arabic (ar)Oman (OM)ar-OM
Arabic (ar)Qatar (QA)ar-QA
Arabic (ar)Saudi Arabia (SA)ar-SA
Arabic (ar)Sudan (SD)ar-SD
Arabic (ar)Syria (SY)ar-SY
Arabic (ar)Tunisia (TN)ar-TN
Arabic (ar)United Arab Emirates (AE)ar-AE
Arabic (ar)Yemen (YE)ar-YE
Belarusian (be)Belarus (BY)be-BY
Bulgarian (bg)Bulgaria (BG)bg-BG
Catalan (ca)Spain (ES)ca-ES
Chinese (zh)China (CN)zh-CN
Chinese (zh)Singapore (SG)zh-SG(*)
Chinese (zh)Hong Kong (HK)zh-HK
Chinese (zh)Taiwan (TW)zh-TW
Croatian (hr)Croatia (HR)hr-HR
Czech (cs)Czech Republic (CZ)cs-CZ
Danish (da)Denmark (DK)da-DK
Dutch (nl)Belgium (BE)nl-BE
Dutch (nl)Netherlands (NL)nl-NL
English (en)Australia (AU)en-AU
English (en)Canada (CA)en-CA
English (en)India (IN)en-IN
English (en)Ireland (IE)en-IE
English (en)Malta (MT)en-MT(*)
English (en)New Zealand (NZ)en-NZ
English (en)Philippines (PH)en-PH(*)
English (en)Singapore (SG)en-SG(*)
English (en)South Africa (ZA)en-ZA
English (en)United Kingdom (GB)en-GB
English (en)United States (US)en-US
Estonian (et)Estonia (EE)et-EE
Finnish (fi)Finland (FI)fi-FI
French (fr)Belgium (BE)fr-BE
French (fr)Canada (CA)fr-CA
French (fr)France (FR)fr-FR
French (fr)Luxembourg (LU)fr-LU
French (fr)Switzerland (CH)fr-CH
German (de)Austria (AT)de-AT
German (de)Germany (DE)de-DE
German (de)Luxembourg (LU)de-LU
German (de)Switzerland (CH)de-CH
Greek (el)Cyprus (CY)el-CY(*)
Greek (el)Greece (GR)el-GR
Hebrew (iw)Israel (IL)iw-IL
Hindi (hi)India (IN)hi-IN
Hungarian (hu)Hungary (HU)hu-HU
Icelandic (is)Iceland (IS)is-IS
Indonesian (in)Indonesia (ID)in-ID(*)
Irish (ga)Ireland (IE)ga-IE(*)
Italian (it)Italy (IT)it-IT
Italian (it)Switzerland (CH)it-CH
Japanese (ja)Japan (JP)ja-JP
Japanese (ja)Japan (JP)ja-JP-u-ca-japanese
Japanese (ja)Japan (JP)ja-JP-x-lvariant-JP
Korean (ko)South Korea (KR)ko-KR
Latvian (lv)Latvia (LV)lv-LV
Lithuanian (lt)Lithuania (LT)lt-LT
Macedonian (mk)Macedonia (MK)mk-MK
Malay (ms)Malaysia (MY)ms-MY(*)
Maltese (mt)Malta (MT)mt-MT(*)
Norwegian (no)Norway (NO)no-NO
Norwegian Bokmål (nb)Norway (NO)nb-NO
Norwegian Nynorsk (nn)Norway (NO)nn-NO
Norwegian (no)Norway (NO)no-NO-x-lvariant-NY
Polish (pl)Poland (PL)pl-PL
Portuguese (pt)Brazil (BR)pt-BR(***)
Portuguese (pt)Portugal (PT)pt-PT(***)
Romanian (ro)Romania (RO)ro-RO
Russian (ru)Russia (RU)ru-RU
Serbian (sr)Bosnia and Herzegovina (BA)sr-BA(*)
Serbian (sr)Montenegro (ME)sr-ME(*)
Serbian (sr)Serbia (RS)sr-RS(*)
Serbian (sr)Bosnia and Herzegovina (BA)sr-Latn-BA(**)
Serbian (sr)Montenegro (ME)sr-Latn-ME(**)
Serbian (sr)Serbia (RS)sr-Latn-RS(**)
Slovak (sk)Slovakia (SK)sk-SK
Slovenian (sl)Slovenia (SI)sl-SI
Spanish (es)Argentina (AR)es-AR
Spanish (es)Bolivia (BO)es-BO
Spanish (es)Chile (CL)es-CL
Spanish (es)Colombia (CO)es-CO
Spanish (es)Costa Rica (CR)es-CR
Spanish (es)Dominican Republic (DO)es-DO
Spanish (es)Ecuador (EC)es-EC
Spanish (es)El Salvador (SV)es-SV
Spanish (es)Guatemala (GT)es-GT
Spanish (es)Honduras (HN)es-HN
Spanish (es)Mexico (MX)es-MX
Spanish (es)Nicaragua (NL)es-NI
Spanish (es)Panama (PA)es-PA
Spanish (es)Paraguay (PY)es-PY
Spanish (es)Peru (PE)es-PE
Spanish (es)Puerto Rico (PR)es-PR
Spanish (es)Spain (ES)es-ES
Spanish (es)United States (US)es-US(*)
Spanish (es)Uruguay (UY)es-UY
Spanish (es)Venezuela (VE)es-VE
Swedish (sv)Sweden (SE)sv-SE
Thai (th)Thailand (TH)th-TH
Thai (th)Thailand (TH)th-TH-u-ca-buddhist
Thai (th)Thailand (TH)th-TH-u-ca-buddhist-nu-thai
Thai (th)Thailand (TH)th-TH-x-lvariant-TH
Turkish (tr)Turkey (TR)tr-TR
Ukrainian (uk)Ukraine (UA)uk-UA
Vietnamese (vi)Vietnam (VN)vi-VN

No comments:

Post a Comment

Moving OBIEE to new enviroment

  OBI migration to new enviroment   Everyone has at least once had the need to migrate Oracle Business Intelligence (OBI) to a new enviro...