CellPutProportionalSpread Error

Post Reply
Alan Kirk
Site Admin
Posts: 6643
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

CellPutProportionalSpread Error

Post by Alan Kirk »

I thought I'd add this into the Forum in case anyone else ends up searching for it.

It appears that the Applix programmers in their wisdom introduced a change in the behaviour of the TI CellPutProportionalSpread function somewhere between 8.2 and 9.0.

In 8.2.12, if you do a CellPutProportionalSpread of 0 into an area of the cube which is already zero, nothing happens. Everything just chugs along nicely. (And before anyone asks "why?", it's not always 0. But since spreading 0 would (or should) get you 0 anyway, I didn't see the need to burn up a processor cycle doing (what should be) a completely redundant IF test to handle something that might happen every so often or so.)

But by 9.0, someone had come up with a really bright idea. Spread zero into an area which is already zero and you get... an error log!
Error with spreading, error type unknown = 191
Brilliance! Genius! Inspirational! You have a situation that does no harm at all, but rather than leave it as it is, rather than having TI simply say "you beauty, nothing to do here, makes my life easier", no, "improve" matters by cluttering up the log file directory with bogus and irrelevant error messages. Not to mention wasting our time while we try to figure out what this reported "error" is all about.

It's almost as good as the way you get an error when you try to create a string > 255 characters, while ol' 8.2.12 would just ignore it and leave the string as it was.

Pointless errors. Gotta love 'em.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Emixam
Regular Participant
Posts: 155
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: CellPutProportionalSpread Error

Post by Emixam »

Hello,

I just had a new CellPutProportionalSpread error and there was no documentation anywhere so I'll share in case anyone else ends up searching for it.
Error: Data procedure line (44): Error with spreading, error type unknown = 184
You will get an error if you try to use CellPutProportionalSpread when there is a Hold on a cell (i.g., Hold Consolidate). Unlike Error Type = 191, this error will make your Spread fail.

I'm using PA 2.0.8

Have a good day !
Attachments
2020-05-21_09h52_20.png
2020-05-21_09h52_20.png (234.43 KiB) Viewed 2697 times
Wim Gielis
MVP
Posts: 3223
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: CellPutProportionalSpread Error

Post by Wim Gielis »

Now, in a recent PA version:

Code: Select all

Error with spreading, error type unknown = 292
This means applying a CellPutProportionalSpread to an area where you don't have WRITE access.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
holger_b
Posts: 131
Joined: Tue May 17, 2011 10:04 am
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: 2016
Location: Freiburg, Germany

Re: CellPutProportionalSpread Error

Post by holger_b »

Code: Select all

Error with spreading, error type unknown = 292
also occurs in case one of the target dimension subsets contains no element.
Post Reply