TM1 Forum

Can anyone help me in this regard.
I am implementing spreading in Active form.
The values below are at consolidation level. When I do spreading to the cells which are having values, let say proportional spreading, the values are flowing back to the leaf level. However, when I try to do spreading on the cell which is holding value '0' error occurs and the spreading is not perform. Being a consolidation level it is not allowing user even to enter value in the zero cells.

Is it that the consolidation/leaf level values are zero so the system is not allowing spreading? or any missing recipe?

In order to allow users to do spreading on zero values cell, what is the perfect approach? Is there anything to be done? Please advice.



Destination Region No.of Liftings
-------------------------------------------------------
LGCCNA - China 1,929
LGCGLF - Middle Eastern Gulf 7,423
LCGISC - ISC 648
LGCFEA - FE / SE Asia 0
- z - Total 10,000

The concept of breakback as in EP does not quite apply to TM1. In EP if you breakback over a previously emply region the value will be evenly applied to all underlying cells. In TM1 you can only proportional spread over a region that has data (unless you are doing a relative spread).

The answer is you need to do a relative proportional spread and base the input number on data elsewhere in the cube in order to fill the underlying cells. (Or you could have a paramatized TI process to pre-fill or "seed" numbers prior to doing the spread.)

I believe this is available as a new feature in 9.5.2. But if you're on a prior version then you'll have to look at some thing as suggested by lotsaram.