TI Functions

Turbo Integrator uses SQL like commands to interrogate data for loading into cubes or updating dimensions. This section gives detailed information about using TI functions and how they can be applied to real world examples.

Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule

I was asked the other day how to concatenate some information in TM1. Joining two text fields is really…

CubeProcessFeeders – Forcing TM1 to Reprocess Feeders

In the rules for many cubes we work with there are conditional feeders. These often cause us problems…

ItemReject TM1 Function: Syntax and Use

Sometimes we want to put some custom text directly into the TM1 Message log to record why something…

ViewZeroOut TM1 Function: Syntax and Use

I came across this extremely simple method of just zapping the data from a view in a TM1 cube…

TODAY TM1 Function: Syntax and How to Use

The TODAY function returns today’s date in a text string and allows you to define the year as either 2 or 4 characters.

STR TM1 Function: Syntax and Use

STR is a TM1 function that converts a number to string. It is very similar to the Excel…

DayNo TM1 Function: How to Use and Syntax

Here we are going to explain how to use the DAYNO TM1 function to convert a date as…

RIGHT TM1 Function: Use and Syntax

If you are looking for the RIGHT function in TM1, you’ll find that it doesn’t actually exist! Instead it is a combination of SUBST and LONG functions. This post give’s a step-by-step explanation into how to achieve the same result in TM1.

LONG TM1 Function: Syntax and Use

The LONG function in TM1 returns the length of a string as a value.  It is similar to…

LEFT TM1 Function: Use and Syntax

The LEFT function from Excel does not exist in TM1. We need to use SUBST instead. Where you…

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement