TI Functions

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...

DimensionElementDelete Function TM1: Syntax and Use

Posted on Jun 25, 2018 by John

Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete permanently deletes the element from the TM1 dimension and all associated data from any...

CubeSetLogChanges TM1 function: Syntax and Example

Posted on Jun 3, 2018 by John

When we run a Turbo Integrator process in TM1, the Transaction Log will normally have a record written for each data change. To speed up the TI, we can turn...

CreateHierarchyByAttribute Function in TM1: Syntax and Use

Posted on May 31, 2018 by Boon Ong

We have recently done a project where we needed to create an excel report showing attributes from the same dimension as the rows and columns in a report. Traditionally in...

DType Function in TM1: Syntax and Use

Posted on Apr 13, 2018 by John

One of the team were just writing a TI to load a text file into TM1. It was all working swimmingly until he tried to load a string (a 3...

MONTH Function in TM1: Syntax and Use

Posted on Dec 5, 2017 by John

The Month function in TM1 extracts a numeric version of month from a text string that represents a date, where the date has been presented in either YYYY-MM-DD or YY-MM-DD format....

Checking if an Attribute Exists (essentially an “AttributeExists” Function)

Posted on Nov 27, 2017 by John

Have you ever looked for a TM1 function that checks if an attribute exists, something like say “AttributeExists” or “AttrExists”. Well there isn’t one. But, don’t dispair, here is a...

Date Function in TM1: Syntax and Use

Posted on Oct 31, 2017 by John

The DATE function in TM1 converts a serial date to a text version of the date in either YYYY-MM-DD or YY-MM-DD format. For example, let’s say you have a date...

Date and Time Functions in TM1 10.2

Posted on Jun 26, 2017 by Ivan Kulman

There are three Date and Time formatting functions for TM1 10.2. Let’s take a closer look at these new functions. If you have had to deal with date changes in a...

Using the DimensionCreate Function to Create a Dimension in TM1

Posted on Jun 21, 2017 by John

Often we will want to create dimensions in TM1. We might be creating a new model or recreating a dimension during a TI process. To do this we use the DimensionCreate...

Need help with TM1?
We're here for you