Turbo Integrator

TM1 RoundUp Function: Method, Syntax and Use

The RoundUp function doesn’t exist in TM1 like it does in Excel. However, here is a really simple…

INT in TM1: Finding the Largest Integer Less Than or Equal To a Specified Value

The INT function allows you to return the nearest integer less than or equal to a specified value….

How to find the Largest of Two Values in TM1: MAX Function: Syntax and Use

The Max function will deliver to you the largest of two numbers. For example, if you have 50…

How to Convert a Text Date-time to a Numeric Element

Do you know how to convert a text date-time into a numeric (or full serial datetime) element in…


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…

Error Codes in TM1 Turbo Integrator – Helpful Cheat Sheet

A simple list of all the TM1 Turbo Integrator error codes and what they mean, listing the error, the severity and what it means.

How to Delete All Elements from a TM1 Dimension: DimensionDeleteAllElements

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.

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