TI Coding

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

Cascading Element Level Security in TM1

Posted on Feb 17, 2018 by John

We are doing a large project at a multi business unit company. The client is very security conscious and wants to ensure t members of a business unit can only…

Checking if an Attribute Exists (essentially an “AttributeExists” Function)

Posted on Nov 27, 2017 by John

Have you ever looked for a TM1 function that checks if an attribute exists, something like say “AttributeExists” or “AttrExists”. Well there isn’t one. But, don’t dispair, here is a…

AsciiOutput with Pipe Delimiter

Posted on Feb 17, 2017 by John

Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can connect directly and publish from TM1 to SQL Server, but I just…

How to Create Headers in AsciiOutput

Posted on Dec 4, 2015 by John

I was creating a text file the other day using AsciiOutput and then realised that I needed to have a header line in there with column headers. The column headings…

WHILE TM1 Function: Syntax and Use

Posted on Dec 3, 2015 by John

Sometimes in a TI process we need to run loops. This is often done to aggregate data prior to loading or exporting. The TI process we use for this is…

Commenting Out Rule and TI Lines

Posted on Dec 2, 2015 by John

Every wondered how to comment out a Rule or Turbo Integrator process in TM1? Well today I needed a method of commenting out text from a rule and, although I…

Operators in TI IF Statements

Posted on Sep 24, 2014 by John

Ever wanted to create a command similar to an SQL “IS IN” in a TM1 Turbo Integrator process? Or use operators in a TM1 TI process to create a “NOT IN”…

Indenting TI Processes and Rules in TM1

Posted on Sep 5, 2014 by John

Often when we write rules or TI’s it is tempting to just get it written and worry about making it readable another time. If you can indent your code as…

Need help with TM1?
We're here for you



Keen to chat? Book a discovery call!