I have a dataview in which I want sales persons to add the number of quantities that they will sell per month. For this I only want them to be able to enter whole numbers and not decimals. With the validation rule I am already able to set that the number should be zero or higher (so negative numbers are not allowed), however it it still possible to enter decimal numbers into the dataview and therefore also in the cube.
As it should be possible to enter numbers above 32.000 I cannot limit the cube to an integer value, so I had to set it to double.
I can hide the decimals in the dataview, however this then also makes it invisible if decimals are used.
I prefer to have a rounding solution somewhere, but I am not sure how to solve this.
Who can help me?