New TI Editor

Advertisements, add-ons and other commercial information
digger1914
Posts: 6
Joined: Thu Jun 05, 2008 3:34 am

New TI Editor

Post by digger1914 »

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!
User avatar
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

Post by garry cook »

I'd be very interested in this. If you start to utilise, could you post up your finding please?

TIA
Paul Segal
Community Contributor
Posts: 306
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

Post by Paul Segal »

I'm getting a demo of this in the next couple of weeks. It's from Cubewise - pdf puff attached.

Regards
Attachments
Cubewise Extend for TM1 TI.pdf
(446.53 KiB) Downloaded 25456 times
Paul
User avatar
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

Post by Steve Vincent »

cheers Paul, sounds fantastic :D
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
User avatar
Martin Ryan
Site Admin
Posts: 1988
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

Post by Martin Ryan »

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.
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
rossi
Posts: 29
Joined: Tue Jun 10, 2008 8:50 pm
Location: London UK

Re: New TI Editor

Post by rossi »

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
User avatar
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

Post by John Hobson »

Maybe they should give the company to the partner community.
Ah you mean like Palo :lol:
John Hobson
The Planning Factory
Adam Buckle
Posts: 6
Joined: Thu Aug 28, 2008 4:30 am

Re: New TI Editor

Post by Adam Buckle »

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 :D and hopefully mitigate the organisation's reliance on me as a "technical expert", which I hate :x Will go along way in standardising the outcomes in TI and more significantly improving productivity.
User avatar
Steve Rowe
Site Admin
Posts: 2410
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

Post by Steve Rowe »

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
User avatar
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

Post by John Hobson »

PARDON?

I'M FORTY NINE YOU KNOW!
John Hobson
The Planning Factory
User avatar
jim wood
Site Admin
Posts: 3951
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

Post by jim wood »

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
User avatar
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

Post by Steve Vincent »

Nuclear?

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
User avatar
jim wood
Site Admin
Posts: 3951
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

Post by jim wood »

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
User avatar
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

Post by John Hobson »

The Fun is clear?
Funiculee, funniculaa
John Hobson
The Planning Factory
ScottW
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

Post by ScottW »

Not only do we allow you to choose your font size, but also the font!
Font_and_Size.JPG
Font_and_Size.JPG (31.8 KiB) Viewed 1070921 times
Cheers,
Scott W
Cubewise
www.cubewise.com
User avatar
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

Post by Steve Vincent »

...and it's still more readable that the one we've got in the standard editor! :lol:
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
User avatar
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

Post by George Regateiro »

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.
User avatar
Alan Kirk
Site Admin
Posts: 6606
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

Post by Alan Kirk »

George Regateiro wrote:We just had a cubewise led demo and are working with a trial.
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.

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.
User avatar
jim wood
Site Admin
Posts: 3951
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

Post by jim wood »

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
User avatar
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

Post by Roger_Lewin »

Any News about this? Looks like the editor the world has waited for...
Post Reply