TI code gets misplaced in data tab

Post Reply
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

TI code gets misplaced in data tab

Post by BariAbdul »

Talking about annoying things,I found another one,Whenever I am saving a process in the middle of developement it saves fine no error but when I come back next day when I open the process it gives me an error on a close look either CellPutN or CellGetN statement or ASCIIOUPUT statement are misplaced and I am getting missing quote or character error.Basically ,this is happening mainly in Data tab for me.for example

Code: Select all

CellPutN(value,vube,a,b,c,d
);
It is really hit my nerves and bit flaky.I wonder any of Gurus came across any similar behaviour.Thanks
"You Never Fail Until You Stop Trying......"
Wim Gielis
MVP
Posts: 3230
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: TI code gets misplaced in data tab

Post by Wim Gielis »

Sure, we see this all the time in good old TI Editor. (well, more "old" than "good" honestly).
I see this most of the time when putting a comment sign (#) in front of a relatively long line of text.
This works, but coming back after some time, TM1 splits the line in 2 lines, and the second part does not have the # character. Hence, I must go in again and add the #.
Pretty annoying yes.


Another one... in the parameters section of the process, you can change Numeric and String only 1 at a time.
So you must change them one after the other.

But I found out myself that the 4 columns are tab-delimited. So if you paste 4 columns, tab-delimited, and a given number of rows, then TI accepts the input :-) Check it out :-)
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
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TI code gets misplaced in data tab

Post by lotsaram »

BariAbdul wrote:Talking about annoying things,I found another one,Whenever I am saving a process in the middle of developement it saves fine no error but when I come back next day when I open the process it gives me an error on a close look either CellPutN or CellGetN statement or ASCIIOUPUT statement are misplaced and I am getting missing quote or character error.
When saving a process and when executing a process on the server a line of code is simply a line of code regardless of how long. (Actually a line of code can be over multiple lines it is simply whatever until the next semi-colon excepting the situation where # is the first non blank character whereupon the line is treated as comment).

This is all well and good but there is a limitation somewhere where on reopening for editing the TI editor will wrap or break the line at somewhere between 120 - 140 characters (can't remember exactly). For a comment this will invariablz cause an error on the next recompilation. For code lines it depends where the break is, if it is in the middle of an operator or variable name then error otherwise all OK just maybe not as well formatted or aesthetically pleasing.

To avoid this just get into the habit of "pre-breaking" your lines at around 120 characters.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: TI code gets misplaced in data tab

Post by BariAbdul »

Thanks Wim and lotsaram ,The strange part is it is not even near 120 characters.Thanks for the advice though. :)
"You Never Fail Until You Stop Trying......"
wilsonmax
Posts: 34
Joined: Fri Feb 28, 2014 2:21 am
OLAP Product: TM1
Version: 10.1.0
Excel Version: 2010

Re: TI code gets misplaced in data tab

Post by wilsonmax »

My experience:
So far, it never happen on TM1 10.1.x I've ever seen.
However, it has happened recently on a TM1 which was just upgraded from 9.5.2 to 10.2.2 (server = 10.2.2; client still = 9.5.2)

My question:
Does anyone know, is this problem limited to a specific version of TM1 client?
Post Reply