Page 1 of 1

TI Editorsaurus Generating Incorrect CELLPUTN function

Posted: Fri Aug 23, 2013 2:20 pm
by erik664
This is version 10.1.1

I just got a very strange error where TI generated a CELLPUTN function that had an extra comma. I fixed it by reselecting the cube on the Maps tab, but I thought it was really weird. Has anyone else run into this sort of thing?

Re: TI Editorsaurus Generating Incorrect CELLPUTN function

Posted: Fri Aug 23, 2013 2:43 pm
by declanr
Interesting, I haven't ever really used the wizard so maybe someone more accustomed to it will provide an obvious response but since you are on v10, it's not relating to a cube that previously had a different number of dimensions and then had a dimension added/removed through performance modeler?

Re: TI Editorsaurus Generating Incorrect CELLPUTN function

Posted: Fri Aug 23, 2013 2:46 pm
by jim wood
Most people don't use the GUI within the processes. I only use the GUI to quickly generate a formula. Then I revert all variables to other. I don't think anybody relies on the GUI for running anything. If your new to TM1 you might not be aware of the GUIs issues. If you are welcome,

Jim.

Re: TI Editorsaurus Generating Incorrect CELLPUTN function

Posted: Fri Aug 23, 2013 2:58 pm
by erik664
declanr wrote:Interesting, I haven't ever really used the wizard so maybe someone more accustomed to it will provide an obvious response but since you are on v10, it's not relating to a cube that previously had a different number of dimensions and then had a dimension added/removed through performance modeler?
Nope. It was a brand new process that was filling a cube up from an ODBC connection where none of the variables had to be adjusted and the data was just dumped into the cube as is. I would only use the wizard in this simple instance. I was getting ready to just write out the function myself if it wasn't going to work by reselecting it.

Re: TI Editorsaurus Generating Incorrect CELLPUTN function

Posted: Mon Aug 26, 2013 8:17 am
by Steve Vincent
I've seen it happen a few times in my models in 9.5.2, so it's not limited to 10 either. I rarely use the GUI though...


...and i'm still :lol: at Editorsaurus

Re: TI Editorsaurus Generating Incorrect CELLPUTN function

Posted: Mon Aug 26, 2013 8:37 am
by Wim Gielis
Never seen this one before. That said, I rarely ever use the wizard, so chances are very small I would see that error :-)

Re: TI Editorsaurus Generating Incorrect CELLPUTN function

Posted: Wed Aug 28, 2013 4:20 pm
by whitej_d
This can happen as the TI wizard only rewrites the generated code when you click on the advanced tab, not when you change the settings in the Maps tab. So you can get situations where old code is evaluated against variables which no longer exist, or have changed name etc.

I've notice that if you accidentally map the same variable to 2 different dimensions on the dimensions tab, it will generate code with a blank, hence 2 commas next to each other.

Re: TI Editorsaurus Generating Incorrect CELLPUTN function

Posted: Wed Aug 28, 2013 9:09 pm
by Wim Gielis
Another strange issue with the Editorsaurus, it happens when connecting to a Cognos package using the connector:
See the different attachments below, right below the "Generated statements" area.
The ONLY thing I do, is saving. Upon each save, 2 lines of whitespace are added :-)