How to always use locale NL — Oracle Analytics

Oracle Analytics Cloud and Server

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

How to always use locale NL

Received Response
61
Views
2
Comments

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