TM1 Forum

Hi all,

I need to spread a monthly budget in weeks using a proportonial relative spreading method based on the same data distribution related to the same period in the previous year.

So, when I put a value at consolidated level of month, data are spread at leaf level (weeks) using equal spread when I would like an automatic proportional relative spreading.
At the moment, I have to perform for each cell the proportional relative data spreading causing frustration in my work!
So, can you advice me how can I set the default data spreading in order to achieve my target?

Many thanks in advance

Regards

You could use a TI process to accomplish this and skip the manual input altogether: calc weekly value as percent of month in the prior year and apply that percent to the monthly value from current year.