Key figure is displayed as 2.007 not 2007, any solution?

Dear Sirs,

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?

best regards,

Jørgen Ruud