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
How to always use locale NL

Summary
How to always use locale NL
Content
I have a requirement that for a .rtf template the output is allways in the locale for the Netherlands regardless of any other settings. In the options menu of the BI Publisher plugin therefore I have set the locale to "Dutch/Netherlands [nl-nl]". For instance in the .rtf document I use the following to ensure the EURO sign is displayed and we use a grouping seperator for the field: €<?format-number: GLB_PROD_004_c; ' 9G990'?>
However when I enter 14500 in the field it diplays it as 14,500 instead of 14.500. What I am missing here to ensure that it allways wil display 14.500? Was setting the locale on this level not enough to ensure this? Is there another syntax possible for '9G990' to ensure this?
We use Oracle Policy Automation to generate the BI publisher reports.
Many thanks in advance for your reply.
Answers
-
Hello,
Try to see if you can enter this code, and replace the Spanish language
<?xdoxslt:pat_format_number(Proyecto/AporteParticipantes/Monto,‘#,##0’,‘es-ES’)?>
References: https://docs.oracle.com/cd/E10415_01/doc/bi.1013/e12187/T421739T481158.htm
best regards
0 -
Declare the format at the very start of your template:
<xsl:decimal-format xdofo:ctx="begin" name="NL" decimal-separator="," grouping-separator="."/>
Show the formatted number:
<?format-number(NUM_COLUMN,'#.###.###.##0','NL')?>
0