Rule Functions
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.
DType Function in TM1: Syntax and Use
One of the team were just writing a TI to load a text file into TM1. It was all working swimmingly until he tried to load a string (a 3...
MONTH Function in TM1: Syntax and Use
The Month function in TM1 extracts a numeric version of month from a text string that represents a date, where the date has been presented in either YYYY-MM-DD or YY-MM-DD format....
Date Function in TM1: Syntax and Use
The DATE function in TM1 converts a serial date to a text version of the date in either YYYY-MM-DD or YY-MM-DD format. For example, let’s say you have a date...
Operators in TM1 Rule IF Statements
Do you need to create an IF expression in a TM1 rule with a logical operator? To create something that is like and AND or OR from SQL but do...
What is Skipcheck in TM1?
Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. So if you had 30 days in a month and data in only...
Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule
I was asked the other day how to concatenate some information in TM1. Joining two text fields is really easy! Just use the pipe ( ” | ” ) between two...
TODAY TM1 Function: Syntax and Use
TODAY simply returns the current system date as a string in the form ‘yy-mm-dd’, or if you want, in the format ‘yyyy-mm-dd’. Syntax of TODAY The syntax is Today (...
STR TM1 Function: Syntax and Use
STR is a TM1 function that converts a number to string. It is very similar to the Excel function “TEXT”, except you don’t need to specify the format of the...
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....
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....
Need help with TM1?
We're here for you
Variance Analysis and Commentary using TM1