User define function in TI

Post Reply
wang_chris
Posts: 122
Joined: Thu Jan 31, 2013 1:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007

User define function in TI

Post by wang_chris »

Just in curious, whether TM1 10.1 or above provide user define function in TI ?

I have a 100+ line code to be used in several places of same TI program. There would be very long for whole program, if I paste these code in every place. Can I write a user define function and call this function in right place?

Regards,
Chris
Gabor
MVP
Posts: 170
Joined: Fri Dec 10, 2010 4:07 pm
OLAP Product: TM1
Version: [2.x ...] 11.x / PAL 2.1.13
Excel Version: Excel 2016-2021-365
Location: Germany

Re: User define function in TI

Post by Gabor »

Not possible in native TM1 TI.
However, recently added functions in TM1 10.2.2 like ExecuteJavaN / ExecuteJavaS should give the option to put your repeating code into a Java class and call it as a single line in your TI code.
I haven't done any testing on that so far, so I can't tell you the impact on TI performance.
User avatar
Steve Rowe
Site Admin
Posts: 2464
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: User define function in TI

Post by Steve Rowe »

You can also use ExecuteProcess to call one TI from another, not sure what your common code does but if you need to pass values back to the calling process then you can either use global variables or write the values into a cube.
Probably a bit easier than learning Java..... ;)
Technical Director
www.infocat.co.uk
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: User define function in TI

Post by tomok »

The java capability in TI is not talked about much but it really is a pretty big deal, assuming you have a java developer on hand or want to learn it. Now, all the things that TI can't natively do, it can now do with a bit of additional work. I've seen a lot of posts lately about populating cubes from a web service. Seems like a java extension to TI would fit the bill perfectly. You could probably even find open source code in the java world to give you a head start.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply