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
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?
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
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
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)
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
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
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
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
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
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
Keen to chat? Book a discovery call!
