How To Change The Decimal Separator And/Or Thousands Separator in 11g

This blog is an attempt to share a Oracle Tech note to wider audience. 

How to change the decimal and thousand separator in OBIEE?

The thousands and decimal separators are defined based on your language settings under Settings/My Account/Locale.For example, if you select English it will use ',' as the thousands separator, but it you select Spanish it uses '.'.

Steps to follow to change the convention:

1. Make a backup copy of the localedefinitions.xml file in the BI_HOME\Oracle_BI1\bifoundation\web\display directory.

2. Make a backup copy of this file (localedefinitions.xml).

3. Edit the file and search for  language code used in your system, i.e.
  <localeDefinition name="es">     <!-- spanish - base -->
 
in this section modify the following lines to contain the desired characters:

     <property name="decimalSeparator">,</property>
     <property name="thousandsSeparator">.</property>


Note that if you use a language code, such as:

<localeDefinition name="es-ve" basedOn="es"> 

<!-- spanish - venezuela -->

you will also need to modify the following parameter in this section too:
 

<property name="decimalSeparator">,</property>

The thousands Separator parameter is not shown in this section.

4. Save the file.

5. Stop and restart all of the BI Services

6. Clear the browser cache

7. Retest

I hope you find this shared information useful.