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:
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.
Your suggestions & queries welcome. Please provide me feedback of this tool.
TM1 Rule Auto Complete & Format add-in for Editplus
-
- 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
Last edited by krishnadixit on Mon Jul 10, 2017 6:13 am, edited 1 time in total.
-
- 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
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
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.
- 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
Thanks Krishna,
Another option is Notepad ++
Nova Hartanty lists the syntax highlighter file here: http://blog.tm1tutorials.com/2012/09/24 ... r-notepad/
Another option is Notepad ++
Nova Hartanty lists the syntax highlighter file here: http://blog.tm1tutorials.com/2012/09/24 ... r-notepad/
-
- 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
I am trying to add edit plus, But where is TM1_Addin_4_Editplus.rar file??
-
- 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
The file link is there in my first post.Tm1andTm1 wrote:I am trying to add edit plus, But where is TM1_Addin_4_Editplus.rar file??
However, here it is again for you.
-
- 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
Thank u so much Krishna......Now it is working fine