Turbo Integrator

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.

Rounding in TM1 – The Complete Guide!

ROUND and ROUNDP are often confused and users expect them to behave the same as the Excel function. They are very similar but are different to the Excel treatment. Here is a complete explanation of both functions, a comparison to Excel ROUND and screenshots of the usage of both functions.

Selective Clear Cube based on Variable Source Data

Detailed instructions on how to clear a variable selection of data that is going to be reloaded from the source. Includes sample TI code and explanations.

StringToNumber TM1 Process: Use and Syntax

StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator processes. From there it can be used mathematically.

DimensionElementPrincipalName, Syntax and Use

DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in TM1 in a TI process.

TM1 Clear Attribute – an AttrClear Function

The AttrClear or ClearAttr function doesn’t exist in TM1. Here is an easy method to replicate what functions like these would do, with a downloadable example

YEAR Function in TM1: Syntax and Use

The YEAR function in TM1 allows us to extract the number representing the Year from a date. Here we explain it’s syntax and give an example combining it with the DATE function.

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