‘@= in TM1: How to Use it in Rules and Processes
‘@= is used in TM1 for evaluation of operators in TM1 Rules and TI Processes. Here we explain how it is used and give examples for both rules and processes.
How to do a Daily or Weekly Restart of a TM1 Model
How to safely save data and shut down a TM1 server (model) when it is run as a Windows Service and then how to restart that TM1 service automatically.
Date and Time Functions for Easy Date Manipulation
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.
DimensionCreate: How to Create a Dimensions in a TM1 Process (TI)
To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.
"Joining" Text Files in a TM1 Turbo Integrator Process
How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.
Data Export Tool Review – Flyspeed
Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this […]
Indenting TI Processes and Rules in TM1
How to use indents to layout Rules and Turbo Integrator processes in TM1 so they are easier to read.
Transfering Data between TM1 Servers using ODBO (i.e. Without CSV's)
This blog shows the steps needed to establish an ODBO connection in order to transfer data between 2 cubes in different server instances.
Triggering TI Processes from TM1 Application Workflow
How to trigger a TM1 Turbo Integrator process after a workflow state has been changed in a TM1 Contributor Application.
Managing Applications from Command Line
Managing TM1 Applications from a command line, or via a Windows batch file. In other words using the TM1 windows based utility “app_maintenance.bat” to execute TM1 processes from Windows.
TM1 10.2 – New Feature: Enable/Disable Applications from Commandline
In this new release of TM1 10.2, a new feature has been added to allow users to perform application maintenance using command line, or in a batch file. The main purpose of this utility is to automate some of the application maintenance, using a combination of standard TI processes and TI processes that execute commands […]
Testing Turbo Integrator Code
In the last post we talked about how we can output String and Numeric values in a Fixed Width Field Format. I realised just after writing the article that I used a not-well-known trick in order to perfect the snippets I posted. This is: Using Calculated Variables to Test Field Calculations. I’m going to use […]
Fixed Width File Format from TM1
When outputting data from TM1 usually we can get away with comma separated values format. Which is standard functionality from a Turbo Integrator process [See ASCIIOutput, TextOutput functions]. Every now and then we need to interface with a ERP system which requires Fixes Width Fields. This presents a few problems, not insurmountable but still not expressly easy either. The […]
Notepad++ for TM1 Rules & TI – Download – Updated!
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++.
Woohoo! TM1 Tutes has cracked 100,000 visits!
This is just a shout out to all the administrators, support teams and developers who have browsed or subscribed to the TM1 Tutorials blog over the last two years. Thanks, your the best and we are so pleased to have the opportunity to share our time tested tips and tricks with you all If you are […]
How to Write easily Understood Turbo Integrator Code
Improving Turbo Integrator Code: A Comprehensive Guide
Turbo Integrator Syntax Highlighter (Notepad++)
It is no secret that syntax highlighting script editors increase developer productivity. I regularly find myself staring at a chunk of TI processes (especially those written by someone else) for far too long. The combination of black and white text with small, crowded fonts in Turbo Integrator doesn’t help with the readability at all. While […]
Automating Data Transfers Between TM1 Servers
Replicating a Cube from a one TM1 Server into another has never been easier. Follow the steps below to copy a cube from one server to another (this includes synchronising TM1 Dimensions). This process uses the ODBO Provider for TM1 and generated MDX. I was going to show how to create an MDX Query for the desired […]
Creating and Expanding a Time Dimension
This post should really be titled “Creating a Time Dimension with a method which allows it to be easily expanded later.” but that simply wont fit. The concept is simple, where previously a time dimension is manually updated and eventually becomes tiresome to update (once every few years) we can instead use one process to […]
CubeSpy TM1 Server Monitor – Open Beta Release!
CubeSpy Server Monitor provides TM1 Administrators with visibility and notifications about what their TM1 Servers are doing. Features: Connect to Multiple TM1 Servers of Different Versions. Monitor as many TM1 Servers as you have. Profile Creation – Group Servers by Version, Location. Windows Tray Icons Displaying Server Queues Graph with Color Coding Monitor User Idle […]