TM1 coding extension for VSCode

Post Reply
ndivine
Posts: 19
Joined: Wed Feb 23, 2011 6:43 pm
OLAP Product: TM1
Version: Latest
Excel Version: 2013

TM1 coding extension for VSCode

Post by ndivine » Fri Jan 18, 2019 3:25 pm

We just put out a free TM1 coding extension for VSCode (also free).

I've been doing my TM1 coding in VSCode for several months now and I think it's a great environment and the extension makes it even better with syntax highlighting, code snippets, etc.

Happy coding!
https://marketplace.visualstudio.com/it ... tm1-helper

CellPutN
Posts: 22
Joined: Mon Oct 01, 2018 1:50 pm
OLAP Product: TM1
Version: 10.2.20500.75
Excel Version: 2016
Location: Montreal, Canada

Re: TM1 coding extension for VSCode

Post by CellPutN » Sat Jan 19, 2019 5:59 pm

Well done !! Much better and PAW or TI Helper from Cubewise.

But I have a question.
IMPORTANT: IBM Planning Analytics/Cognos TM1 does not allow for direct editing of the .RUX and .PRO files. All editing must be done by copying the appropriate text from the standard TM1 interfaces and pasted into VSCode. Editing can take place there, and once changes are completed, pasted back into the standard interface (such as Process Editor or Rules Editor)
Is there a parameter or something in the tm1s.cfg that we can change to allow direct editing of the .RUX or .PRO files ?

Wim Gielis
MVP
Posts: 2052
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.7
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: TM1 coding extension for VSCode

Post by Wim Gielis » Sat Jan 19, 2019 9:26 pm

CellPutN wrote:
Sat Jan 19, 2019 5:59 pm
But I have a question.

Is there a parameter or something in the tm1s.cfg that we can change to allow direct editing of the .RUX or .PRO files ?
I doubt it very much.
For me, what works best until now, is using AutoHotKey to have a hotkey (F10) copy the code of the selected tab and paste into Notepad++, either a new file in an open instance, either a new instance. Another hotkey transfers the code back to the TI editor. I assume you would need a similar approach. Or use the TM1 REST API to update a certain tab of the process based on the code. In Notepad++ I have on the first line of the document the information of the window that will receive the code again.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 service with AutoHotKey

ndivine
Posts: 19
Joined: Wed Feb 23, 2011 6:43 pm
OLAP Product: TM1
Version: Latest
Excel Version: 2013

Re: TM1 coding extension for VSCode

Post by ndivine » Mon Jan 21, 2019 8:20 pm

Wim Gielis wrote:
Sat Jan 19, 2019 9:26 pm
CellPutN wrote:
Sat Jan 19, 2019 5:59 pm
But I have a question.

Is there a parameter or something in the tm1s.cfg that we can change to allow direct editing of the .RUX or .PRO files ?
I doubt it very much.
For me, what works best until now, is using AutoHotKey to have a hotkey (F10) copy the code of the selected tab and paste into Notepad++, either a new file in an open instance, either a new instance. Another hotkey transfers the code back to the TI editor. I assume you would need a similar approach. Or use the TM1 REST API to update a certain tab of the process based on the code. In Notepad++ I have on the first line of the document the information of the window that will receive the code again.
There's no parameter that I know of. Unfortunately, that's just an annoying but necessary part of using these text editors for coding. It looks like Wim streamlined it a bit, I just do it the old fashioned way.

Wim, I find your MDX page very useful, I use it all the time.

Emixam
Posts: 6
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: TM1 10.2
Excel Version: 2016

Re: TM1 coding extension for VSCode

Post by Emixam » Wed Jun 12, 2019 4:32 pm

Hello ndivine,

Is it me or the syntax highlighting no longer works ? Thanks
Attachments
tm1helper.png
tm1helper.png (39.67 KiB) Viewed 151 times
Last edited by Emixam on Mon Jun 17, 2019 7:33 pm, edited 1 time in total.

kangkc
Community Contributor
Posts: 187
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

Re: TM1 coding extension for VSCode

Post by kangkc » Thu Jun 13, 2019 7:58 am

With the GIT support in PA 2.0.7, this may work.

Emixam
Posts: 6
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: TM1 10.2
Excel Version: 2016

Re: TM1 coding extension for VSCode

Post by Emixam » Mon Jun 17, 2019 6:51 pm

No it's not.

Post Reply