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.

ATTRN TM1 Function: How to Use and Syntax within TI and Rules

ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element…

DataSourceCubeView: Syntax, Use and Example

Another piece of the puzzle of setting up an AsciiOutput is to define a view and then export that…

Text File Export from TM1 – AsciiOutput Functions

When we are exporting from TM1 to a text file there is a set of functions we can set that modify…

ViewColumnSuppressZeroesSet

This is one of a set of functions that define the behaviour of a Turbo Integrator AsciiOutput. The…

ViewExtractSkipCalcsSet TM1 Function: Syntax and Use

Allows you to skip Consolidated (or rolled up) values when using an AsciiOutput in a TM1 TI process.

ViewExtractSkipRuleValuesSet TM1 Function: Syntax and Use

This is one of a set of functions that define the behaviour of a Turbo Integrator AsciiOutput. The…

CellGetS TM1 Function: How to Use and Syntax

CellGetS allows you to retrieve a string (text value) from a specific intersection in a TM1 cube for use in a Turbo Integrator (TI) process.

Header Row from AsciiOutput

How to Create a Header Row with AsciiOutput

Here is a great explanation of how to add a row of column headings to an AsciiOutput from TM1.

WHILE TM1 Function: Syntax and Use

Sometimes in a TI process we need to run loops. This is often done to aggregate data prior…

CubeSaveData TM1 Function: Syntax and Use

This is just like the SaveDataAll command, except it is cube specific, rather than saving the data 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