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 is the fastest way to get data from one cube to another via a TI – is it use a view of the source and the CellPut functions to load it or is it faster to Extract and Load?
This is a case study of how to unwind a dimension without deleting all the elements. Includes simple TI code that you can use.
Detailed instructions on how to clear a variable selection of data that is going to be reloaded from the source. Includes sample TI code and explanations.
Here we present a fully worked example of how to create element level security for an organisation that requires complete lockdown for entire branches of a dimension. It uses element level security down to the N level, applied via a TI.
Here is a really easy method for checking if an Attribute Exists in TM1 via Turbo Integrator process. It essentially does what an “AttributeExists” or an “AttrExists” function would do for you if they existed in TM1.
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.
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
Here is a great explanation of how to add a row of column headings to an AsciiOutput from TM1.
In this article, we will discuss While Function in Turbo Integrator – Creating Loops in TI Processes in TM1 and Planning Analytics
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
Have you ever wanted to add SQL like operators directly to your TI processes? Operators like OR, AND, NOT IN, or NOT EQUAL TO. Well here’s how you can.
How to use indents to layout Rules and Turbo Integrator processes in TM1 so they are easier to read.
Here is a downloadable Notepad++ language file for TM1 and Plannign Analytics. Use it to view syntax of TM1 Rules and Turbo Integrator processes in Notepad++.
Improving Turbo Integrator Code: A Comprehensive Guide
We sometimes get asked what are the three most important things to remember in TM1 development to make a TM1 model work well in the long term. Well, here is
Create a new Turbo Integrator Process For now we won’t set the data source for the TI Process because we want this to be a Cube View that we create
Here is all you need to know about TM1 Turbo Integrator processes. What they are, how they work and how to debug them.
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
