Rule Functions

TODAY TM1 Function: Syntax and Use

The TODAY function returns today’s date in a text string and allows you to define the year as either 2 or 4 characters.

STR TM1 Function: Syntax and Use

STR is a TM1 function that converts a number to string. It is very similar to the Excel…

DayNo TM1 Function: Use and Syntax

Here we are going to explain how to use the DAYNO TM1 function to convert a date as…

IF Rules in TM1: Use, Syntax and Examples

IF Function for use in Rules in TM1 and Planning Analytics, full syntax and examples of how to use nesting and alternative to nesting in Rules

RIGHT TM1 Function: Use and Syntax

If you are looking for the RIGHT function in TM1, you’ll find that it doesn’t actually exist! Instead it is a combination of SUBST and LONG functions. This post give’s a step-by-step explanation into how to achieve the same result in TM1.

LONG TM1 Function: Syntax and Use

The LONG function in TM1 returns the length of a string as a value.  It is similar to…

LEFT TM1 Function: Use and Syntax

The LEFT function from Excel does not exist in TM1. We need to use SUBST instead. Where you…

ATTRN TM1 Function: Use and Syntax within TI and Rules

ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element…

ELLEV TM1 Function: Use and Syntax

The ELLEV function returns the numeric value of the level for an element in a dimension in TM1. Syntax…

DIMNM TM1 Function: Use and Syntax

The TM1 function DIMNM returns the name of an element from its index in a TM1 dimension. Each element…

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement