TM1 Forum

Hi All,
We have an issue with data spreading. When we try to spread, it spreads to all available cells to the left or right. Is there a way to prevent from spreading after certain months? Example, put a stop after say 5 months or is there a way to limit spreading on a rule like period of performance? Say period of performane is between Feb-21 to Feb-23, when I spread from Sep-22 it should spread upto Feb-23. Please let me know if there's a way to accomplish this.

Thanks,
Paul.

What is the interface in which you want to accomplish this ?

In PAW you can highlight the cells you want to be part of the spread and then use the right-click spread option, this will let you do all spreading options except "relative xxx" I believe. You don't have to select right, up, down, or left as you have already defined the area to be included by highlighting the cells.

I believe Architect/Perspectives cube viewers, TM1 Web cubeviewers, TM1 Web websheets, and PAX all have the same functionality of being able to highlight cells and then right-click to go to the spread options.

Thanks Wim Gielis. We were trying to accomplishn in Contributor.
Thanks Declnar! That works.


Paul.