TM1 Rule Formatter for TextPad add in

Ideas and tips for enhancing your TM1 application
Post Reply
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

TM1 Rule Formatter for TextPad add in

Post by Ricky Marwan »

Hi All,

Made this rule formatter as TextPad add in.

you may find TextPad here http://www.textpad.com

From:
From Rule
From Rule
from rule.jpg (53.68 KiB) Viewed 7778 times
To:
To Rule
To Rule
to rule.jpg (63.47 KiB) Viewed 7778 times
How to add to textpad:
Unpack to any folder.
In TextPad go to Configure > Preferences > Tools > Add

The attachment file contains TM1 Rule Formatter, Syntax Coloring and Clip Libraries.
For syntax coloring and clip libraries unpack to TextPad System and Samples folder.
TM1RuleFormatter.rar
TM1 Rule Formatter
(32.77 KiB) Downloaded 599 times
Note:
For standard rule writing this works fine.

Requirements:
.Net Framework v4
Ricky Marwan
nedcpatm1
Posts: 23
Joined: Mon Oct 08, 2012 3:39 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2010
Location: Central Minnesota, USA

Re: TM1 Rule Formatter for TextPad add in

Post by nedcpatm1 »

Hi Ricky,

Thanks for sharing add-in and files.

The formatting works nice; however, I cannot seem to color code TM1 syntax.

Any suggestions what I am missing (I have already unpacked syntax coloring and clip libraries to TextPad System and Samples folder)?

Ned
Ricky Marwan
Posts: 32
Joined: Tue Aug 14, 2012 7:47 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: TM1 Rule Formatter for TextPad add in

Post by Ricky Marwan »

Hi Ned,

To Add Syntax Coloring:

- Go to TextPad Configure menu, Configure > New Document Class
- Name it Rule, Next
- Class members *.rux, Next
- Enable Syntax Highlighting and Select rux.syn, Finish

Repeat for TI syntax

You can change Tab spacing, indent size, Color for specific keyword in Configure > Preferences menu.
Ricky Marwan
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 Formatter for TextPad add in

Post by krishnadixit »

Hi Ricky,

I just checked it, nice one.
Hey I also have made similar add-in for Editplus, its here http://www.tm1forum.com/viewtopic.php?f=21&t=8056

-Krishna
nedcpatm1
Posts: 23
Joined: Mon Oct 08, 2012 3:39 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2010
Location: Central Minnesota, USA

Re: TM1 Rule Formatter for TextPad add in

Post by nedcpatm1 »

Hi Ricky,

It worked. Thanks
Post Reply