Oracle Analytics and AI

Edp Sviluppo

Summary

Decimal separator in Oracle BI Publisher 12.2.1.0.0

Content

Hi all,

I need to change the decimal separator character "dot" (.) with "comma" (,)

In Italy we use the comma as decimal separator.

All the query that return number fileds in Excel are shown as strings because in Italian version the "dot" isn't a decimal separator.

Performing a REPLACE in the SQL statement will result that Excel shows correctly the string but still in string format not in number, so sorting and filtering are not number but string option.

I think that a the decimal character separator must be changed globally in the Oracle BI Publisher 12.2.1.0.0 installation.

Anyone has the same or a similar request ?

Thank you

Mirko

Vani-R

Try changing in backend using to_char for ex:-

SELECT

to_char(108767,'99999G990D00', 'NLS_NUMERIC_CHARACTERS = '',.''') FROM DUAL .

In RTF template, documentation says you can use format-number with decimal-format, but i have not used it.

for ex:-

<xsl:decimal-format name="european" decimal-separator=',' grouping-separator='.' />

<?format-number:CF_END_BALANCE;'999G999G990D00','european'?>