New TI Editor
-
- Posts: 6
- Joined: Thu Jun 05, 2008 3:34 am
New TI Editor
Last night I went to a presentation in Sydney about, amongst other things, a new text editor for TI that is about to be released by CubeWise, a Sydney company. This looks like the editor we (or at least I) have been waiting for!
From what I remember, it:
* works through the TM1 API
* has a colour, larger font text editor
* allows you to collapse sections of text
* store your processes in sub folders, not all in a root directory
* open a process without it automatically running SQL
* seemed to have decent debugging and error messages
* allows you to conmpile & check for errors without saving the process
* contains snippets of pre recorded code
* auto completes functions etc when you start entering them
* lets you rename processes using F2 like you do in Windows
There was other stuff, but I can't remember it all.
It also has an SQl editor built in, that allows you to select tables and graphically join fields whilst it generates the SQL for you. The code can then be cut into the editor.
Looks like a great toy. No mention of price, and release is in "about a month". Sorry, but I forgot what name they gave it!
From what I remember, it:
* works through the TM1 API
* has a colour, larger font text editor
* allows you to collapse sections of text
* store your processes in sub folders, not all in a root directory
* open a process without it automatically running SQL
* seemed to have decent debugging and error messages
* allows you to conmpile & check for errors without saving the process
* contains snippets of pre recorded code
* auto completes functions etc when you start entering them
* lets you rename processes using F2 like you do in Windows
There was other stuff, but I can't remember it all.
It also has an SQl editor built in, that allows you to select tables and graphically join fields whilst it generates the SQL for you. The code can then be cut into the editor.
Looks like a great toy. No mention of price, and release is in "about a month". Sorry, but I forgot what name they gave it!
- garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
Re: New TI Editor
I'd be very interested in this. If you start to utilise, could you post up your finding please?
TIA
TIA
-
- Community Contributor
- Posts: 312
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Re: New TI Editor
I'm getting a demo of this in the next couple of weeks. It's from Cubewise - pdf puff attached.
Regards
Regards
- Attachments
-
- Cubewise Extend for TM1 TI.pdf
- (446.53 KiB) Downloaded 25675 times
Paul
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Re: New TI Editor
cheers Paul, sounds fantastic 

If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
- Martin Ryan
- Site Admin
- Posts: 1989
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: New TI Editor
Quick run down
- Nice ability to group ti processes by things like data source type, or searches for *MyProcess*
- "Hot promote" ability to take a TI object from dev environment into a live environment (plans to do this with other objects in the pipeline)
- Query builder similar to Access's GUI
- Code grouping ("regionalising") allows you to hide code, similar to Excel's grouping feature, which can be nested
- Standardised code can be inserted via snippets, which is extendable. E.g. building views
- Debug functionality saves the effort of writing your own asciioutput code (best feature for me)
- Useful prompts for functions - gives you the syntax and argument order
- Syntax colouring, indenting ifs etc
- Find and replace. Undo and redo.
Summary: good little tool. Price point is fairly sensible. Would recommend to people who have fairly recently graduated from the TI wizard. Not quite enough there yet (for my money) for experienced developers to get ROI, but I think it will get there fairly quickly with a few extensions to the debug ability. My demo was a little buggy with a few crashes, but it was still a pre-release version.
Bundled with an initial buy I think it makes sense - consultants, it might be worth investigating as a resellable product. Demoes much better than the TI editor if you need to demo (for example) a pull in from a ODBC GL.
Worth getting a demo anyway.
- Nice ability to group ti processes by things like data source type, or searches for *MyProcess*
- "Hot promote" ability to take a TI object from dev environment into a live environment (plans to do this with other objects in the pipeline)
- Query builder similar to Access's GUI
- Code grouping ("regionalising") allows you to hide code, similar to Excel's grouping feature, which can be nested
- Standardised code can be inserted via snippets, which is extendable. E.g. building views
- Debug functionality saves the effort of writing your own asciioutput code (best feature for me)
- Useful prompts for functions - gives you the syntax and argument order
- Syntax colouring, indenting ifs etc
- Find and replace. Undo and redo.
Summary: good little tool. Price point is fairly sensible. Would recommend to people who have fairly recently graduated from the TI wizard. Not quite enough there yet (for my money) for experienced developers to get ROI, but I think it will get there fairly quickly with a few extensions to the debug ability. My demo was a little buggy with a few crashes, but it was still a pre-release version.
Bundled with an initial buy I think it makes sense - consultants, it might be worth investigating as a resellable product. Demoes much better than the TI editor if you need to demo (for example) a pull in from a ODBC GL.
Worth getting a demo anyway.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
Re: New TI Editor
Wow, who is the smart one at Cubewise that developed that? I must congratulate them.
Seems partners do more than the owners of this product these days. Maybe they should give the company to the partner community.
Paolo
Seems partners do more than the owners of this product these days. Maybe they should give the company to the partner community.
Paolo
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
Re: New TI Editor
Ah you mean like PaloMaybe they should give the company to the partner community.

John Hobson
The Planning Factory
The Planning Factory
-
- Posts: 6
- Joined: Thu Aug 28, 2008 4:30 am
Re: New TI Editor
I am also testing the product. Works great. Well done Ben, Jason et al.
Still waiting for a few bugs so as to work straight off a 64-bit box.
Agree with some of Martin's points but a big plus for me is it reduces a risk. Ie IT and boss speaking: "what happens if you get hit by a bus? Will anyone know what you have done in TI and still be able to run the system? " This will become my answer to this question
and hopefully mitigate the organisation's reliance on me as a "technical expert", which I hate
Will go along way in standardising the outcomes in TI and more significantly improving productivity.
Still waiting for a few bugs so as to work straight off a 64-bit box.
Agree with some of Martin's points but a big plus for me is it reduces a risk. Ie IT and boss speaking: "what happens if you get hit by a bus? Will anyone know what you have done in TI and still be able to run the system? " This will become my answer to this question


- Steve Rowe
- Site Admin
- Posts: 2455
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: New TI Editor
One thing that this does, which I know some of my older colleagues will appreciate, is that you can have the font any size you like. This of course means that you can actually read the script you are writing which I've known to be an issue, let alone debugging it.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: New TI Editor
I'll tell my Dad. He'll be well chuffed. Does it also come with a work all button? Too many buttons = confussion.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Re: New TI Editor
Nuclear?
i'll get my coat...
i said i'll get my coat!
i'll get my coat...
i said i'll get my coat!
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: New TI Editor
What was that? My hearing aid is playing up? The Fun is clear?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
-
- Regular Participant
- Posts: 152
- Joined: Fri May 23, 2008 12:08 am
- OLAP Product: TM1 CX
- Version: 9.5 9.4.1 9.1.4 9.0 8.4
- Excel Version: 2003 2007
- Location: Melbourne, Australia
- Contact:
Re: New TI Editor
Not only do we allow you to choose your font size, but also the font!
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Re: New TI Editor
...and it's still more readable that the one we've got in the standard editor! 

If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
- George Regateiro
- MVP
- Posts: 326
- Joined: Fri May 16, 2008 3:35 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2007 SP3
- Location: Tampa FL USA
Re: New TI Editor
We just had a cubewise led demo and are working with a trial.
As far as the Extend TI Editor it seems to do a fairly good job of tackling some of the real annoyances of TI. Debugging, not running the SQL repeatedly, intellisense and copying processes to a new server without the hassle of restarting. We saw a beta (they are talking about a December release) and though there was issues it is a very good first pass. As someone who coded in Visual Studio for years going to TM1 was a huge step back and this tool brings back some of the productivity tools that you start to rely on.
In talking with their rep I was also impressed that they seem very dedicated to producing a whole suite of administration products to fill the gaps where Cognos seems to be ignoring some of the glaring holes in the entire application management side. Given the dev time I really think that these guys can produce some really great tools for the user base.
As far as the Extend TI Editor it seems to do a fairly good job of tackling some of the real annoyances of TI. Debugging, not running the SQL repeatedly, intellisense and copying processes to a new server without the hassle of restarting. We saw a beta (they are talking about a December release) and though there was issues it is a very good first pass. As someone who coded in Visual Studio for years going to TM1 was a huge step back and this tool brings back some of the productivity tools that you start to rely on.
In talking with their rep I was also impressed that they seem very dedicated to producing a whole suite of administration products to fill the gaps where Cognos seems to be ignoring some of the glaring holes in the entire application management side. Given the dev time I really think that these guys can produce some really great tools for the user base.
-
- Site Admin
- Posts: 6644
- 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:
Re: New TI Editor
Sigh... I was so looking forward to trying this thing out. Alas I can't put it on my server until I've checked it out on an isolated machine first, which would be my notebook. Then my notebook's screen died and I had to get a new one. And thus far I haven't finished installing all of the software on it.George Regateiro wrote:We just had a cubewise led demo and are working with a trial.
Remember when getting a new computer was fun? Now it's a boooooooring, teeeeeedious chore.
And I can't remember where my CS2 disks are, and CS3 was an upgrade.
Sorry, I drifted off topic there...
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: New TI Editor
Call me daft if you will but I actually enjoy rebuilding machines. That's why I never bother with ghost. I just keep all software on a USB hard drive, attach it after the OS installation is finished and then do the rest. Told you it is fun!!
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- Roger_Lewin
- Posts: 17
- Joined: Mon Nov 03, 2008 8:25 am
- Version: 9.4 MR1 FP1
- Excel Version: 2003
- Location: Ratingen, Germany
- Contact:
Re: New TI Editor
Any News about this? Looks like the editor the world has waited for...