All the Oracle Software’s comes with default as English-United States locale, this is something that gets some of us confused, because we don’t have any idea what a locale means. Frankly it doesn’t matter as it is mostly end user specific and Developers doesn’t bother about this very often. However end user happiness being the ultimate agenda of all the Software projects we are more inclined to enquire and acquire knowledge on this area.
Locale settings are something that are derived based on the region specific formats followed in the real time and are set to be followed by application, let’s take the OBIEE locales available in the localedefinitions.xml file which defines locale settings of different regions across the globe.
Some Example of Locale Settings
- Date Format
US - MM-DD-YYYY
- Language
France - French (fr)
Similar to the above we have date separator, Time Separator, Date Order, First day of week etc which may vary based on a country or region.
In OBIEE 12c, there are two files which hold information on these locale settings, localedefenitions.xml and localemapppings.xml located in below folder
[Oracle_Home]/bi/bifoundation/web/display
you can verify the default by logging on to the analytics and in my account you will find the below details by default.
If you want to change the default Locale to a different one to that of United States, please follow the below steps
- Open the localemappings.xml file from above Location
- Locate and change the below lines as shown to change it to English - United Kingdom
- Restart the complete OBIEE services
What exactly needs to be changed in localemappings.xml ?
ReplyDeleteHi...updated looks like the HTML tags were gone before
DeleteExcellent!
ReplyDelete