Category Archives: Turbo Integrator

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.

This entry was posted in Logging, TI Functions and tagged CubeSetLogChanges, Transaction Log. Bookmark the permalink. | Tagged CubeSetLogChanges, Transaction Log | Leave a comment

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.

This entry was posted in Attributes, TI Functions and tagged CreateHierarchyByAttribute, HierarchyDestroy, HierarchyExists. Bookmark the permalink. | Tagged CreateHierarchyByAttribute, HierarchyDestroy, HierarchyExists | Leave a comment

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.

This entry was posted in Rule Functions, TI Functions and tagged CellIncrementN, CellPutN, CellPutS, DType. Bookmark the permalink. | Tagged CellIncrementN, CellPutN, CellPutS, DType | Leave a comment

Cascading Element Level Security 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.

This entry was posted in Security, TI Coding, TM1 Admin, TM1 Administration, Turbo Integrator and tagged CAM Security, element level security, Element Security, Security. Bookmark the permalink. | Tagged CAM Security, element level security, Element Security, Security | 1 Comment

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.

This entry was posted in Rule Functions, TI Functions and tagged Date, Dates, Month. Bookmark the permalink. | Tagged Date, Dates, Month | Leave a comment

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.

This entry was posted in TI Coding, TI Functions and tagged AttributeExists, AttrInsert, DimensionCreate, DimensionExists, dimix. Bookmark the permalink. | Tagged AttributeExists, AttrInsert, DimensionCreate, DimensionExists, dimix | Leave a comment

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’.

This entry was posted in Rule Functions, TI Functions and tagged Date. Bookmark the permalink. | Tagged Date | Leave a comment

Date and Time Functions in TM1 10.2

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.

This entry was posted in TI Functions, TM1 10.2 and tagged FormatDate, NewDateFormatter, ParseDate, Time, Turbo Integrator. Bookmark the permalink. | Tagged FormatDate, NewDateFormatter, ParseDate, Time, Turbo Integrator | Leave a comment

Using the DimensionCreate Function to Create a Dimension in TM1

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

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

Checking if a DimensionExists in a TM1 Model

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

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment