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