TI Processes

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

How to Create Virtual Dimensions in TM1/Planning Analytics

Posted on Nov 1, 2018 by Boon Ong

Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability.  Here we briefly discuss what they are and then what you need to…

“Joining” Text Files in a TM1 Turbo Integrator Process

Posted on Jun 16, 2017 by John

I was faced with an interesting situation yesterday. I needed to load information from a header and a detail table into TM1. So, just do a join in the TI,…

CubeClearData TM1 Function Syntax and Use

Posted on Feb 10, 2016 by John

CubeClearData clears all of the data in a cube. It is a TurboIntegrator function, valid only in TurboIntegrator processes. This function is much faster than doing an operation such as creating a…

Null Values in a Turbro Integrator Process

Posted on Oct 30, 2015 by John

I recently needed to check some data I was loading via a Turbo Integrator process in TM1 for Null values. I thought there’d be something like an IsNull (like in…

TM1 SaveDataAll Data Locks

Posted on Oct 21, 2015 by John

Recently I encountered a situation where we had a SaveDataAll process running every half hour that had started impacting the system performance.  The environment is largely for enterprise planning and we…

Exporting Data from TM1 to an External Database

Posted on Jun 18, 2015 by John

I needed to create a rollup in a data warehouse the other day from elements that are stored in TM1. This process works just as well for SQL Server, Oracle,…

DatasourceNameForServer and DatasourceNameForClient TM1 Functions: Use and Syntax

Posted on Apr 8, 2015 by John

Ever wondered how you can vary the data source for a Turbo Integrator process inside the actual process so it becomes dynamic? Well here is a method. Firstly, define a…

ELLEV TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

The ELLEV function returns the numeric value of the level for an element in a dimension in TM1. Syntax The syntax is ELLEV(dimension, element); where: dimension, is the dimension you are…

How to Pad a Variable Length Element in TM1

Posted on Mar 18, 2015 by John

Often we have a situation were we want to create a dimension with the contents of a code from a source system.  Sometimes, however the IDs in the source system are…

ItemSkip TM1 Function: Use and Syntax

Posted on Mar 3, 2015 by John

ITEMSKUP is a Turbo Integrator function that forces the current record being read from a data source to be skipped. Syntax of ITEMSKIP The syntax is just ITEMSKIP; – real simple…

Need help with TM1?
We're here for you



Keen to chat? Book a discovery call!