TI Best Practices

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 Convert a Text Date-time to a Numeric Element

Posted on Jan 6, 2022 by John

Do you know how to convert a text date-time into a numeric (or full serial datetime) element in TM1? For example, if you have an Excel file as the original…

What’s the Fastest Method to Copy Data from Cube to Cube?

Posted on Jun 5, 2020 by John

We did an interesting experiment the other day about copying data from one TM1 cube to another. We tested to see how much faster it is to use an extract…

Selective Clear Cube based on Variable Source Data

Posted on Oct 22, 2019 by John

Once I needed to load some motor vehicle fleet data from a csv file.  I thought it had unique records for each measure, month and car. Easy, I thought. I’ll…

Element Level Security – Cascading through a Dimension in TM1

Posted on Feb 17, 2018 by John

We are doing a large project at a multi business unit company. The client is very security conscious and wants to ensure that members of a business unit can only…

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 and Time Functions for Easy Date Manipulation

Posted on Jun 26, 2017 by Ivan.Kulman

There were three Date and Time formatting functions released with TM1 10.2. These allow you to easily manipulate dates within a TI. Let’s take a closer look at these new…

AsciiOutput with Pipe Delimiter

Posted on Feb 17, 2017 by John

Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can connect directly and publish from TM1 to SQL Server, but I just…

How to Create a Header Row with AsciiOutput

Posted on Dec 4, 2015 by John

Asciioutput is a great way to export data from TM1. The problem with it is that it does not automatically add a header row at the top of the file…

WHILE Function: How to Use, Syntax, and Examples

Posted on Dec 3, 2015 by John

Sometimes in a TI process we need to run loops. This is often done to aggregate data prior to loading or exporting. While function is the TI process we use…

Commenting Out Rule and TI Lines

Posted on Dec 2, 2015 by John

Every wondered how to comment out a Rule or Turbo Integrator process in TM1? Well today I needed a method of commenting out text from a rule and, although I…

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!