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
User define function in TI
-
- Posts: 122
- Joined: Thu Jan 31, 2013 1:03 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
-
- 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
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.
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.
- 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
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.....
Probably a bit easier than learning Java.....

Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- 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
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.