PAW Forecast Feature - Ver. 2.0.62

Post Reply
mlorini
Posts: 15
Joined: Tue Apr 06, 2021 8:44 pm
OLAP Product: TM1
Version: 2.8
Excel Version: 365

PAW Forecast Feature - Ver. 2.0.62

Post 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
Attachments
PAW_Forecat.JPG
PAW_Forecat.JPG (27.1 KiB) Viewed 3341 times
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: PAW Forecast Feature - Ver. 2.0.62

Post 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.
Declan Rodger
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: PAW Forecast Feature - Ver. 2.0.62

Post by macsir »

Try to forecast some simple detailed cells first to see if it works.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
mlorini
Posts: 15
Joined: Tue Apr 06, 2021 8:44 pm
OLAP Product: TM1
Version: 2.8
Excel Version: 365

Re: PAW Forecast Feature - Ver. 2.0.62

Post 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:
Attachments
paw-timeout.JPG
paw-timeout.JPG (20.58 KiB) Viewed 3299 times
Post Reply