Thursday, February 28, 2013

Change Locale in OBIEE 11g

How to change locale for all users there are 2 things that need to be done

i am assuming that you want to make en-au as the standard locale for every user

a. add the following tags in the instanceconfig.ini located at <MiddlewareHome>/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/
<ServerInstance>

<Localization> 

<AllowedLanguages>en</AllowedLanguages>

<AllowedLocales>en-au</AllowedLocales>

</Localization>

</ServerInstance> 
  
b. edit the localemappings.xml file located in <MiddlewareHome>/Oracle_BI1/bifoundation/web/display/ 
  
and change the line 
  
<when matches="en*"><localeDefinition name="en-us"/></when> 
  
to 
  
<when matches="en*"><localeDefinition name="en-au"/></when> 
  
also note that if you want to make further customization to the locale like if you want a - in the date format instead of the / then the file to edit is 
  
<MiddlewareHome>/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/localedefinations.xml