TI Best Practices

What’s the Fastest Method to Copy Data from Cube to Cube?

What is the fastest way to get data from one cube to another via a TI – is it use a view of the source and the CellPut functions to load it or is it faster to Extract and Load?

Selective Clear Cube based on Variable Source Data

Detailed instructions on how to clear a variable selection of data that is going to be reloaded from the source. Includes sample TI code and explanations.

Element Level Security – Cascading through a Dimension in TM1

Here we present a fully worked example of how to create element level security for an organisation that requires complete lockdown for entire branches of a dimension. It uses element level security down to the N level, applied via a TI.

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

Here is a really easy method for checking if an Attribute Exists in TM1 via Turbo Integrator process. It essentially does what an “AttributeExists” or an “AttrExists” function would do for you if they existed in TM1.

AsciiOutput with Pipe Delimiter

Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can…

Header Row from AsciiOutput

How to Create a Header Row with AsciiOutput

Here is a great explanation of how to add a row of column headings to an AsciiOutput from TM1.

WHILE TM1 Function: Syntax and Use

Sometimes in a TI process we need to run loops. This is often done to aggregate data prior…

Commenting Out Rule and TI Lines

Every wondered how to comment out a Rule or Turbo Integrator process in TM1? Well today I needed…

Operators in a TM1 Turbo Integrator IF Statement

Have you ever wanted to add SQL like operators directly to your TI processes? Operators like OR, AND, NOT IN, or NOT EQUAL TO. Well here’s how you can.

Indenting TI Processes and Rules in TM1

How to use indents to layout Rules and Turbo Integrator processes in TM1 so they are easier to read.

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