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
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)
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
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
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
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
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
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
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
Variance Analysis and Commentary using TM1