Page 1 of 1
PAW Forecast Feature - Ver. 2.0.62
Posted: Thu Aug 12, 2021 6:05 pm
by mlorini
I was wondering if someone can help me with the PAW Forecast feature.
I was trying to create my first forecast model following the example at:
https://www.youtube.com/watch?v=c8fAftMecw4
However, every time I tried to create a forecast preview I get the same error (see attached screenshot) "Attemp to update a non-updatable cell"
Thanks
Re: PAW Forecast Feature - Ver. 2.0.62
Posted: Thu Aug 12, 2021 7:59 pm
by declanr
It likely means that it worked out a forecast and then tried to place it in cells which are either derived by rules (so it can’t put a value there) or protected by security (also can’t put a value there.)
Can you check the intersection you are running it for and see if you have access? If there are c-level cells it will try and write to the underlying n-level elements. And if the starting value is zero it will default to trying to do an equal spread to ALL underlying leaf cells.
Re: PAW Forecast Feature - Ver. 2.0.62
Posted: Thu Aug 12, 2021 9:19 pm
by macsir
Try to forecast some simple detailed cells first to see if it works.
Re: PAW Forecast Feature - Ver. 2.0.62
Posted: Fri Aug 13, 2021 4:15 pm
by mlorini
Well, I find the solution to my issue:ProportionSpreadToZeroCells was set to F in the tm1s.cfg file
#
https://www.ibm.com/support/pages/syste ... s-be-false
ProportionSpreadToZeroCells=T
now I have the following issue: