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.


ELWEIGHT TM1 Function: How to Use, Syntax & Example

Ever wondered how you can use the weight assigned to an element in a hierarchy in a rule…

DAY TM1 Function: How to Use, Syntax and Example

The TM1 DAY function extracts the Day of Month number from a string based date. For example, DAY (’21-09-18′) will return the number 18.

DimensionDestroy: How to Delete a Dimension in TM1

Sometimes we want to just delete a dimension from TM1. We get lots of failed searches on our…

DimensionDeleteAllElements: How to Use, Syntax & Example

Have you ever needed to just delete all elements from a dimension in TM1? Well there is a…

Sleep in TM1: How to Pause a TI Process

Full explanation of the Sleep function in TM1, with syntax and example so you can pause your Turbo Integrator process.


ELCOMP TM1 Function: How to Use and Syntax

In TM1, ELCOMP returns the child element at a specified numeric position of a parent. Full syntax and explanation for use.

ELCOMPN TM1 Function: How to Use & Syntax

In TM1 and Planning Analytics, ELCOMPN returns the number of children an element has Full syntax and explanation for use.

DimensionElementInsertDirect Function: Syntax & Use

DimensionElementInsertDirect directly adds a new element to a TM1 dimension immediately – no need to wait for the end of the TI step.

ELISPAR TM1 Function: Use and Syntax

ELISPAR tests if an element is a direct child of a parent in a dimension in TM1. Here we explain how to use it, provide examples and compare it to ELISANC.

ConsolidatedAvg TM1 Function: Syntax, Use and Examples

ConsolidatedAvg is used to calculate a single consolidated average value of child values at the n level. For…

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