TM1 Forum

Quantity is a integer . Even applying data spreading on Quantity, it supposes to return a integer.
Can it be done in TM1 ?

Hi,

To give you a better answer I would need to understand what you mean by 'Even applying data spreading...' but generally speaking it can be tricky to achieve this as you would always have to know how many cells you are spreading to.

What you could try though is to spread on one measure and have a rule for another measure do a rounding to the next integer.
The function INT() comes to my mind.

Cheers

Gregor

what if the cell is for user input(DBRW), once you set a rule for the cell, you no longer able to edit the cell .

and In my cube , there is a column call QTY .It's a integer .
For some reason ,i need to apply data spreading on this column .
after spreading ,the QTY need to remain a integer value.

e.g.
let's say ,i need to spread 10 to 3 cell , it return 3.33 to each cell.
The result is not i want .
In that situation , I perfer either return 3 to each cell or 1 cell 4 and remain cell 3

What you are wanting to do can't be done in a single step. If you are proportional spreading down to leaf level then each leaf will receive a new value in proportion to the old leaf value/consol value and new total for the consol. This won't necessarily be an integer at leaf level, in fact it is more than likely not going to be.

You could have a 2 step process to rule derive an integer value from the spread as per Gregor's suggestion then relative proportional spread the integer values back to the original measure that is open for data input.

This is a little clunky but will work if you must have integer values (however your total consol value is likely to be a little out due to rounding of the leaves.)