Quantity is a integer . Even applying data spreading on Quantity, it supposes to return a integer.
Can it be done in TM1 ?
Data Speading on quantity
-
Gregor Koch
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: Data Speading on quantity
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
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
Re: Data Speading on quantity
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
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
-
lotsaram
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Data Speading on quantity
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.)
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.)