Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Decimal separator in Oracle BI Publisher 12.2.1.0.0

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