I have a key figure called Year, of type Int 4. This is being filled from a day using the DATE_YEAR function in the update rule.
When it is displayed in Bex Web it is shown as 2. 007 (with a dot and a space). As far as I can see it also saved in this format in the actual data.
How can I display this as 2007 and not 2. 007 ?
I have tried different things, using the nodim() and the trunc() in the update rule. I have also tried to change the scaling factor in Bex Query designer on the key figure.
I am aware that changing the display format in SU3 could solve it, but I would like to solve it independant of the different users, and make it only valid for this key figure.
Can anyone help me?