TI Case Studies

Turbo Integrator creates processes that can be executed.

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

How to Create Virtual Dimensions in TM1/Planning Analytics

Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we explain how to create them with code examples.

CubeClearData TM1 Function Syntax and Use

CubeClearData: TM1 and Planning Analytics command for clearing all data from a TM1 cube without deleting and recreating the cube. It does not give the flexibility of deleting the data from only a slice of a cube.

Null Values in a Turbro Integrator Process

This is a short and simple post to help you check for null values. There is no direct TI command to check if values being loaded are null or not, but we have come up with two easy checks to search for a string or numeric null value.

TM1 SaveDataAll Data Locks

Recently I encountered a situation where we had a SaveDataAll process running every half hour that had started…

Exporting Data from TM1 to an External Database

I needed to create a rollup in a data warehouse the other day from elements that are stored…

DatasourceNameForServer and DatasourceNameForClient TM1 Functions: Use and Syntax

Ever wondered how you can vary the data source for a Turbo Integrator process inside the actual process…

How to Pad a Variable Length Element in TM1

Often we have a situation were we want to create a dimension with the contents of a code from…

ItemSkip TM1 Function: Use and Syntax

ITEMSKUP is a Turbo Integrator function that forces the current record being read from a data source to…

TM1 Archive TI Process

I asked Mafia Man the other day how I can take a backup on the fly of everything…

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