Wednesday, April 12, 2017

Number format in BI Publisher



Show the numbers in Swiss-German, instead of German-German.

1. Change the Locale setting while creating BI Publisher template. open Options > Preview > change Locale to [de-CH]
2. Have the field formatting as  <?format-number:field_name;'999G999D00'?>
3. Login to PeopleSoft application and change the Language settings by following steps:
  • PeopleTools > Utilities > International > Languages
  • For Language Code 'GER' change the ISO Locale to "de-ch"
  • Save and restart the AppServer