TM1 Forum

Hi,

Can any one help me in Proportional spreading code.

In Excel/Active form -> users doesn't want to use Proportional spreading feature available in perspectives. Can anyone help me with any code? or any other technique?

Thanks in advance

Read the TM1 documentation behind the TI function CellPutProportionalSpread, which looks like CellPutProportionalSpread(number, Dim1, Dim2,Dim3...,Dimx). It takes the number you provide and, starting with the spot in the cube defined by the intersection of Dim1, Dim2, Dim3...,Dimx proportionally spreads it down to the lowest level of each dimension.

If the users' only problem is using Perspectives, then they can do it just as easily in an Excel slice or active form. Right click on the DBRW formula and select "Data Spread". There's a list of options there that covers the same list as in the cube viewer.

What type of spreading are they trying to do?

There are a number of simple techniques (using rules and lookup cubes) to allow users to enter annual values and spread this annual balance accross months based on different spread methods eg 4-4-5 or workdays or any other custom method you want

there are also the spreading shortcuts such as entering r>1000 into perspectives or excel will repeat 1000 to all cells to the right

Steve

In Excel/Active form -> users doesn't want to use Proportional spreading feature available in perspectives. Can anyone help me with any code? or any other technique?

Am i reading correctly that you are trying to block the capability of spreading (or at least proportionnal spread)?

Meaning not right clicking the cell and not clicking proportionnal spread is not good enougth maybe for process/security purpose ?
i.e force user to specify their nlevel budget entry manually instead of authorising the spreading ?

I don't think you can achieve that through Tm1 configuration.

See this other post ( almost related).
http://www.tm1forum.com/viewtopic.php?p=1110