No idea where to set German number formatting

Arc & Slice
,
1

Hi,
I have purchased a new arc license and would like to have the numbers displayed in a cube view in German format (###.##0,00).I have not found a setting for this in the “arc”.
If I choose directly in the arc for the “format” attribute for the title dimension “Komma” then it saves: #.##0,00 for an element and this doesn’t work because it is not accepted by TM1. (I think this is an arc bug, since an incorrect format results from a selection).
For the rest of the “arc” frontend it is enough to set the language “Deutsch” as topmost in the list in Chrome, but not for the number format.
Actually only comma and dot should be swapped as thousands and decimal separator for German number format.
Environment:

  • local arc service on a Windows 10 profession OS
  • TM1 instance on a remote server Windows 2012 (tm1s.cfg: Language=deu)
  • TM1 version of tm1sd.exe: 11.8.1.36
  • Chrome Version 64Bit: 87.0.4280.141

Best regards
Olaf Franke

2

Hi @OlafFranke,

Although Arc supports German language translations for the UI, it does not currently support the German numbering format.
In other words:
Using a dot to indicate thousands and a comma to indicate decimals for a given number.

That being said, this is something we can look to include as a future enhancement.

Can you raise a ticket at the link below please?
Please remember to use the Feature Request template when opening a new issue.

Thanks,
Gerhard

3

Hi,

Does anyone know if this was added to ARC?

Cheers,
Vivek

4

Hi @vivek ,

When working with Slice, there are 4 settings that you can update:

  1. Slice Settings is the language used when entering data in Excel
  2. Web browser setting is used when entering data in the Server Explorer
  3. Current Caption Language is used to display TM1 captions
  4. TM1 Server lanquage

image
image1797×827 171 KB

I understand that when working with Europe and having users in many countries this can lead to some confusion.

Cheers,

Vincent

5

Thank you, Vincent!

6

Hi @vivek ,

In my previous post, I forgot to add the Windows Regional Settings.

Please find below a table showing the language settings and which feature is impacted:

image
image2172×396 31.8 KB

What is the most confusing is the cube viewer, if it is used via the web browser then the language is driven by the web browser, if it is used inside the Slice Server Explorer then the language is driven by the Windows Display Language.

I hope this help,

Cheers,

Vincent

1 Like