Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 55 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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