I have a cube view that shows numeric values as a dimension (2 dec) with the number of occurences as value. In the pivot table the values are shown as 2 decimals. In the chart it shows more decimals, even when the number of decimals is determined in SQL (cast .. as numeric(11, 2)).
Is there a way to change this behaviour?
Is it possible to reduce the initial scale?