TM1 Rule Auto Complete & Format add-in for Editplus

Ideas and tips for enhancing your TM1 application
Post Reply
krishnadixit
Posts: 31
Joined: Fri Oct 14, 2011 6:44 am
OLAP Product: TM1, COGNOS
Version: TM1 9_5 Cognos Planning 8_4
Excel Version: 2007
Location: Mumbai, India

TM1 Rule Auto Complete & Format add-in for Editplus

Post by krishnadixit »

Hi CPMians,

After developing "TM1 Documenter" software, I thought of having a customized add-in for Rules that would help us in saving time & understanding the rules better (atleast visually as compared to standard & advanced Rule Editor)

Although its an Add-in for Editplus (probably not much known to TM1 gurus & developers but other developers & progrmmers, specifically java programmers know Editplus very well), I am positive that you all would like it.

You may download latest version of Editplus from http://www.editplus.com

Features:
a) Color formatting for TM1 rules' reserved words.
b) TM1 Function Auto completion prompting for argument(s).
For example: If we want to use db function, in the editplus editor just type db & hit space.
The add-in will automatically print DB( cube, e1, e2, [...e256]);
This helps us in knowing what arguments, number of arguments, & other information is required for DB function.
Also after typing DB & hitting space, not only it displays above line, but it also places the current cursor just before
1st argument as "DB( <current cursor>" that helps us in typing / editing the arguments.

Here is the sample of TM1 rules that will look like in Editplus with my add-in:
TM1_Editplus_Addin.PNG
TM1_Editplus_Addin.PNG (42 KiB) Viewed 11623 times
How to use:
Assuming that Editplus software has been successfully installed on your machine.
1. Extract "TM1_Addin_4_Editplus.rar" to any folder, & copy all the files from that folder to Editplus installed folder.
By default it would be "C:\Program Files\EditPlus <version>\"
2. Now start Editplus software & from Menubar, click Document -> Permanent Settings. Preferences window will open.
3. Click "Add" button that is adjacent to File types window. Type "TM1Rules" without quotes. Hit Ok.
4. In File extensions text box type "rux" without quotes.
5. For syntax file, click button indicated by "..." without quotes, browse to "C:\Program Files\EditPlus <version>\" folder,
and select "tm1rules.stx" file. Hit Open.
6. Check Auto completion box, & browse to "C:\Program Files\EditPlus <version>\" folder, and select "tm1rules.stx" file.
TM1_Editplus_Options.PNG
TM1_Editplus_Options.PNG (17.66 KiB) Viewed 11623 times
TM1_Addin_4_Editplus.rar
(2 KiB) Downloaded 777 times
Your suggestions & queries welcome. Please provide me feedback of this tool.
Last edited by krishnadixit on Mon Jul 10, 2017 6:13 am, edited 1 time in total.
krishnadixit
Posts: 31
Joined: Fri Oct 14, 2011 6:44 am
OLAP Product: TM1, COGNOS
Version: TM1 9_5 Cognos Planning 8_4
Excel Version: 2007
Location: Mumbai, India

Re: TM1 Rule Auto Complete & Format add-in for Editplus

Post by krishnadixit »

Hi all,

I just thought of posting the link of video that will walk you through the demo of How to configure & use TM1 Rules Add-in for Editplus

http://youtu.be/765fm4MaqiU
Last edited by krishnadixit on Mon Jul 10, 2017 6:13 am, edited 1 time in total.
User avatar
jameswebber
Community Contributor
Posts: 188
Joined: Sun Nov 21, 2010 8:00 pm
OLAP Product: Cognos Express 10
Version: CE 10.1.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: TM1 Rule Auto Complete & Format add-in for Editplus

Post by jameswebber »

Thanks Krishna,
Another option is Notepad ++
Nova Hartanty lists the syntax highlighter file here: http://blog.tm1tutorials.com/2012/09/24 ... r-notepad/
Tm1andTm1
Posts: 48
Joined: Thu Apr 11, 2013 7:47 am
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Re: TM1 Rule Auto Complete & Format add-in for Editplus

Post by Tm1andTm1 »

I am trying to add edit plus, But where is TM1_Addin_4_Editplus.rar file??
krishnadixit
Posts: 31
Joined: Fri Oct 14, 2011 6:44 am
OLAP Product: TM1, COGNOS
Version: TM1 9_5 Cognos Planning 8_4
Excel Version: 2007
Location: Mumbai, India

Re: TM1 Rule Auto Complete & Format add-in for Editplus

Post by krishnadixit »

Tm1andTm1 wrote:I am trying to add edit plus, But where is TM1_Addin_4_Editplus.rar file??
The file link is there in my first post.

However, here it is again for you.
TM1_Addin_4_Editplus.rar
TM1 Addin for Editpluss
(2 KiB) Downloaded 648 times
Tm1andTm1
Posts: 48
Joined: Thu Apr 11, 2013 7:47 am
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Re: TM1 Rule Auto Complete & Format add-in for Editplus

Post by Tm1andTm1 »

Thank u so much Krishna......Now it is working fine
Post Reply