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
PAW Forecast Feature - Ver. 2.0.62
-
- 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
- Attachments
-
- PAW_Forecat.JPG (27.1 KiB) Viewed 3341 times
-
- 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
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.
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
- 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
Try to forecast some simple detailed cells first to see if it works.
-
- 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
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:
# https://www.ibm.com/support/pages/syste ... s-be-false
ProportionSpreadToZeroCells=T
now I have the following issue:
- Attachments
-
- paw-timeout.JPG (20.58 KiB) Viewed 3299 times