Skip to main content

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? 

 

 

Hello André, 

I’ve asked this question to our cube specialist and the awnser in would be no.
There is no way to change the used scale.

With kind regards,
Edo Spijker


Unfortunately. I can use an alphanumeric value for the dimension, but this only shows the measured deviations, not to scale.