Category Archives: TI Coding
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.
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 wanted to use the simple method – create a text file and load it up. Problem with Comma Separated Values My problem was that some of the columns contained text that had random commas, so a regular AsciiOutput wouldn’t work … Continue Reading
Here is a great explanation of how to add a row of column headings to an AsciiOutput from TM1.
Sometimes in a TI process we need to run loops. This is often done to aggregate data prior to loading or exporting. The TI process we use for this is called WHILE and it will force a set of commands to repeat until the condition set becomes invalid. Syntax of While WHILE ( logical expression); TI statement1; TI statement2; TI statement n; END; Example Here we want to export both monthly … Continue Reading
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 done it hundreds of times, a brain freeze (call it memory degradation) hit. Anyway a quick check on the internet and I then had one of those “doh” moments. How to Comment Out a Line of Text from a Rule … Continue Reading
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 all you need to know about TM1 Turbo Integrator processes. What they are, how they work and how to debug them.