Change Locale in OBIEE 11g

this is going to be a quick and small one :-) had to search a lot to find out 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>

.....lots of other stuff.....
<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