Monthly Archives: April 2016

The Definitive Guide to Migrating TM1 from Development to Production

Migrating or Deploying TM1 from one environment to another is difficult. This best-practice guide presents two methods that can be used step-by-step to help ensure that your migration is successful. It also includes a downloadable checklist that you can modify to suit your specific TM1 servers and models.

DayNo TM1 Function: Use and Syntax

Yesterday I was doing some work on an inventory forecasting system.  I had Year, Month and Day dimensions and needed to bring through Actuals for all days up until yesterday. I have a System Settings cube with Current Day defined in it using a rule. To bring through the Actuals I created a rule that uses the DayNo function. Syntax of DayNo DAYNO(‘DateString’) So here if you insert a string in … Continue Reading

IF() TM1 Rule Function: Use and Syntax

IF() is a function that can be used to test if an expression is true so that you can then differentially execute a rule based on the outcome of the IF statement. It is able to be used in both Turbo Integrator processes and Rules, however this post is about the use of it in Rules only.  For TI based IF statements, please see this post. Syntax of IF() in Rules The syntax … Continue Reading

How to Add an Existing TM1 Server (Model)

Sometimes we will want to add a copy of an existing TM1 model (server) to our TM1 environment. We might want to do this if, for example, we want to have a Development and Production model that are separated, but on the same server, or we might have been sent a model by someone else and want to be able to use it. To do it is dead easy! How to Add an … Continue Reading

TM1 Log File Cleanup

One of the things that is often overlooked in TM1 is to clean up the log files. There are a few different types of log files, one of which is created every time a SaveDataAll or a CubeSaveData is executed. These save the data in TM1 cubes out to disk, so that if the server crashes, TM1 will be loaded with the last saved data set. Thus you can end up with many of these log … Continue Reading