Flow TM1 Rule Editor

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
Harvey
Community Contributor
Posts: 210
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: TM1, CX, Palo
Version: 9.4+
Excel Version: 2003+
Contact:

Flow TM1 Rule Editor

Post by Harvey » Mon Dec 09, 2013 1:07 pm

Ricky Marwan, the creator of the "TM1 Transporter" and "(Another) TM1Top" has released the first version of his TM1 Rule Editor, for free to the TM1 developer community.

Features:
  • Formatting and colored syntax highlighting make reading and organizing your rules easy.
  • Drag and drop cubes to create DB formulae, or just drag single dimensions to get the bang syntax string.
  • The tool also includes a complete palette of valid TM1 rule functions. Simply drag the function to the rule editor and you'll get the function string along with parameter hints.
If you'd like to give it a try, you can download it from the Flow website.
Flow OLAP - adding value to Cognos Partners worldwide.

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: Flow TM1 Rule Editor

Post by Steve Vincent » Mon Dec 09, 2013 1:24 pm

Seeing as we can't get the advanced editor working within a virtualised distribution of TM1 this looked promising, but is there any way to use it without the need for editing environment variables or running an installer? I have a tightly controlled environment which does not allow me to do either of those tasks, a zipped directory of the necessary files would be perfect tho.
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
Harvey
Community Contributor
Posts: 210
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: TM1, CX, Palo
Version: 9.4+
Excel Version: 2003+
Contact:

Re: Flow TM1 Rule Editor

Post by Harvey » Mon Dec 09, 2013 1:30 pm

Steve Vincent wrote:Seeing as we can't get the advanced editor working within a virtualised distribution of TM1 this looked promising, but is there any way to use it without the need for editing environment variables or running an installer? I have a tightly controlled environment which does not allow me to do either of those tasks, a zipped directory of the necessary files would be perfect tho.
I'll direct Ricky to your post and get an official response, but as far as I know the PATH environment variable is necessary to get it working. With any luck, he'll find a way to get you a portable version.
Flow OLAP - adding value to Cognos Partners worldwide.

sander
Posts: 52
Joined: Thu Dec 09, 2010 9:23 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Re: Flow TM1 Rule Editor

Post by sander » Mon Dec 09, 2013 3:26 pm

I want to try it but does it work with Cam security? I get the next message when I want to log in.
ScreenHunter_92 Dec. 09 16.24.jpg
ScreenHunter_92 Dec. 09 16.24.jpg (32.7 KiB) Viewed 4910 times
Regards,
Sander

User avatar
Harvey
Community Contributor
Posts: 210
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: TM1, CX, Palo
Version: 9.4+
Excel Version: 2003+
Contact:

Re: Flow TM1 Rule Editor

Post by Harvey » Tue Dec 10, 2013 12:20 am

I haven't been able to test here yet, but I'm pretty sure CAM security is unsupported in this initial release.
Flow OLAP - adding value to Cognos Partners worldwide.

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

Re: Flow TM1 Rule Editor

Post by Ricky Marwan » Tue Dec 10, 2013 12:35 am

Harvey wrote:
Steve Vincent wrote:Seeing as we can't get the advanced editor working within a virtualised distribution of TM1 this looked promising, but is there any way to use it without the need for editing environment variables or running an installer? I have a tightly controlled environment which does not allow me to do either of those tasks, a zipped directory of the necessary files would be perfect tho.
I'll direct Ricky to your post and get an official response, but as far as I know the PATH environment variable is necessary to get it working. With any luck, he'll find a way to get you a portable version.
Steve,

For TM1 9.5 version You can copy dll listed below into rule editor program folder

C8ITKProxy.dll
C8ITKShared.dll
libeay32.dll
log4cxx.dll
tm1api.dll
tm1camclient.dll
TM1ULibDll.dll
entire "ssl" folder

Alternatively you can use www.dependencywalker.com to identify required TM1 libraries
Ricky Marwan

User avatar
vinnusea
Posts: 116
Joined: Thu Sep 23, 2010 6:12 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: San Diego ,CA

Re: Flow TM1 Rule Editor

Post by vinnusea » Mon Mar 14, 2016 9:32 pm

Hi Ricky,
Any updates on when you are planning make CAM security compatible ? Unless the editor connects through CAM not many developers can really use it. we love the tool but can't use it.

THanks,
Vinsea
Thanks
Vinnusea

Post Reply