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 » Wed Oct 29, 2008 8:35 pm

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
MVP
Posts: 185
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: 10.2.2 SP4
Excel Version: Various

Re: New TI Editor

Post by garry cook » Fri Oct 31, 2008 9:59 am

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: 243
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: New TI Editor

Post by Paul Segal » Wed Nov 05, 2008 9:20 am

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 844 times
Paul

User avatar
Steve Vincent
Site Admin
Posts: 1048
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 » Wed Nov 05, 2008 2:02 pm

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

User avatar
Martin Ryan
Site Admin
Posts: 1952
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 » Thu Nov 06, 2008 1:40 pm

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 » Sat Nov 08, 2008 2:17 am

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: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Re: New TI Editor

Post by John Hobson » Wed Nov 12, 2008 7:17 am

Maybe they should give the company to the partner community.
Ah you mean like Palo :lol:
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

Adam Buckle
Posts: 6
Joined: Thu Aug 28, 2008 4:30 am

Re: New TI Editor

Post by Adam Buckle » Wed Nov 12, 2008 11:55 am

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: 1767
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: New TI Editor

Post by Steve Rowe » Wed Nov 12, 2008 2:09 pm

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.

User avatar
John Hobson
Site Admin
Posts: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Re: New TI Editor

Post by John Hobson » Wed Nov 12, 2008 2:28 pm

PARDON?

I'M FORTY NINE YOU KNOW!
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

User avatar
jim wood
Site Admin
Posts: 3564
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: New TI Editor

Post by jim wood » Wed Nov 12, 2008 3:51 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Steve Vincent
Site Admin
Posts: 1048
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 » Wed Nov 12, 2008 3:55 pm

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

User avatar
jim wood
Site Admin
Posts: 3564
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: New TI Editor

Post by jim wood » Wed Nov 12, 2008 3:56 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
John Hobson
Site Admin
Posts: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Re: New TI Editor

Post by John Hobson » Wed Nov 12, 2008 4:34 pm

The Fun is clear?
Funiculee, funniculaa
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

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 » Thu Nov 20, 2008 12:13 am

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 10739 times
Cheers,
Scott W
Cubewise
www.cubewise.com

User avatar
Steve Vincent
Site Admin
Posts: 1048
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 » Thu Nov 20, 2008 11:14 am

...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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, 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 » Wed Nov 26, 2008 1:38 pm

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: 5797
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: New TI Editor

Post by Alan Kirk » Wed Nov 26, 2008 10:15 pm

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: 3564
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: New TI Editor

Post by jim wood » Thu Nov 27, 2008 9:40 am

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

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 » Wed Dec 10, 2008 10:33 am

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

Post Reply