Tag Archives: Turbo Integrator

How to do a Daily or Weekly Restart a TM1 Model

How to safely save data and shut down a TM1 server (model) when it is run as a Windows Service and then how to restart that TM1 service automatically.

Date and Time Functions in TM1 10.2

Manipulating dates and times in TM1 has always been horrible. Here we discuss the time manipulation methods available from TM1 v10.2 onwards. These include NewDateFormatter, FormatDate and ParseDate. With them you can even change time from one time zone to another.

Using the DimensionCreate Function to Create a Dimension in TM1

To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.

Checking if a DimensionExists in a TM1 Model

To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.

“Joining” Text Files in a TM1 Turbo Integrator Process

How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.

Data Export Tool Review – Flyspeed

Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this relevant for me? Well, Visual Foxpro is a very close relative of dBase – a … Continue Reading

Indenting TI Processes and Rules in TM1

How to use indents to layout Rules and Turbo Integrator processes in TM1 so they are easier to read.

Transfering Data between TM1 Servers using ODBO (i.e. Without CSV’s)

This blog shows the steps needed to establish an ODBO connection in order to  transfer data between 2 cubes in different server instances.

Triggering TI Processes from TM1 Application Workflow

How to trigger a TM1 Turbo Integrator process after a workflow state has been changed in a TM1 Contributor Application.

Managing Applications from Command Line

Managing TM1 Applications from a command line, or via a Windows batch file. In other words using the TM1 windows based utility “app_maintenance.bat” to execute TM1 processes from Windows.