Hi,
I have a query based on a cube which deals with sales data. In this query a lot of calculations are done based on a small number of base key figures.
As a simple example, turnover (500) devided by quantity (1000) should lead to a price of 0.5.
A week ago I had to add some more calculations and since then all values get rounded. It looks as if the result is no longer a decimal but an integer instead.
The above example now gives me 1 instead of 0.5
Nothing else was changed, just adding some further calculations. Also the base data has not changed. It's a development system where the last data import was in august, 2009 so the data in the cube is correct.
Also if I adjust the formula to: turnover/quantity*1000 the result is 500 (according to the example of the beginning). So for some reason the calculation is done with correct values but the presentation has changed.
I have no clue how to solve this...
Please advice.