Decimal separator in Oracle BI Publisher 12.2.1.0.0 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Decimal separator in Oracle BI Publisher 12.2.1.0.0

Received Response
474
Views
1
Comments

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

Answers

  • Vani-R
    Vani-R Rank 4 - Community Specialist

    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'?>