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.

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.

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.

DATE Function in TM1: Syntax and Use

The Date Function in TM1 converts a serial date from a number to a string. For example Date(13947 , 1); will return the string ‘1998-03-09’.

Date and Time Functions for Easy Date Manipulation

Manipulating dates and times in TM1 has always been horrible. Here we discuss the time manipulation methods available from TM1 v10.2 onwards. These include NewDateFormatter, FormatDate and ParseDate. With them you can even change time from one time zone to another.

DimensionCreate: How to Create a Dimensions in a TM1 Process (TI)

To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.

DimensionExists: Checking if a Dimension is in TM1

To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.

AttrDelete TM1 Function: How to Use and Syntax

To delete an attribute in TM1 or Cognos Express during the execution of a Turbo Integrator process we use the…

AttrInsert TM1 Function: Use and Sytax

Sometimes we want to create a new attribute in TM1 dynamically during the execution of a TI process….

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