Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Does Mondrian support Netherlands number format (switching , with . and . with ,)

  1. #1

    Default Does Mondrian support Netherlands number format (switching , with . and . with ,)

    Hi ,

    Is it possible to represent the number,say for e.g
    25,500.35 as 25.500,35

    using any Format_string option in mondrian ?

    Is there any work around for this?

    Thanks in advance

  2. #2
    Join Date
    Dec 2011
    Posts
    11

    Default Use Locale

    I had the same issue for french numbers.

    I added "Locale=fr_FR" in the datasource.xml :
    Code:
    <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost/myapp?user=myuser&password=mypwd;JdbcDrivers=com.mysql.jdbc.Driver;Locale=fr_FR</DataSourceInfo>

    And I get now my numbers with a comma.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.