Turbo Integrator

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

ELCOMP TM1 Function: Syntax and Use

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

ELCOMPN TM1 Function: Syntax and Use

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.

Use of @= in TM1

@= in TM1: How to Use it in Rules and Processes

@= is used in TM1 for evaluation of operators in TM1 Rules and TI Processes. Here we explain how it is used and give examples for both rules and processes.

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…

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?

ViewConstruct TM1 Function: Syntax and Use

The ViewConstruct function allows you to regenerate a view via a TI so it is then saved in memory on the server. Here we explain the syntax and how to use it.

How to Unwind a Dimension in TM1

This is a case study of how to unwind a dimension without deleting all the elements. Includes simple TI code that you can use.

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