Showing posts with label DATE. Show all posts
Showing posts with label DATE. Show all posts

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

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