Category Archives: 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.

StringToNumber TM1 Process: Use and Syntax

StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator processes. From there it can be used mathematically.

DimensionElementPrincipalName, Syntax and Use

DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in TM1 in a TI process.

TM1 Clear Attribute – an AttrClear Function

The AttrClear or ClearAttr function doesn’t exist in TM1. Here is an easy method to replicate what functions like these would do, with a downloadable example

YEAR Function in TM1: Syntax and Use

The YEAR function in TM1 allows us to extract the number representing the Year from a date. Here we explain it’s syntax and give an example combining it with the DATE function.

How to Create Virtual Dimensions in TM1/Planning Analytics

Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we explain how to create them with code examples.

DimensionElementDelete Function TM1: Syntax and Use

Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete permanently deletes the element from the dimension and all associated data from any cube the dimension is used in – so please be careful!

CubeSetLogChanges TM1 function: Syntax and Example

When we run a Turbo Integrator process in TM1, the Transaction Log will normally have a record written for each data change. To speed up the TI, we can turn off transaction logging for a TI using the command CubeSetLogChanges.

CreateHierarchyByAttribute Function in TM1: Syntax and Use

Here is a great way to create virtual dimensions in TM1 based on attributes. These allow you to intersect multiple virtual dimensions from the same physical dimensions in a PAW or PAX report. Here we discuss the CreateHierarchyByAttribute function and give an example on how to use it.

DType Function in TM1: Syntax and Use

Use, syntax and example of the DType function in TM1 and Planning Analytics. In this post we explain the use of the DType function and give an example of how it can be used to determine the cell type of a cube when loading data via a Turbo Integrator process.

MONTH Function in TM1: Syntax and Use

The MONTH function in TM1 allows us to extract the number representing the Month from a date. Here we explain it’s syntax and give an example combining it with the DATE function.