Rule Functions

STR TM1 Function: Syntax and Use

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

How to Convert a String Date to a Numeric Date in using the DayNo TM1 Function

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

IF Rules in TM1: How to 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: How to 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…

How to Find the Level of an Element in TM1: ELLEV Use and Syntax

Syntax and Use of ELLEV in TM1 and Planning Analytics to determine the level of a particular element from a dimension.

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…

DimSiz TM1 Function: Use and Syntax

The TM1 function DimSiz returns the total number of elements in a TM1 dimension. Syntax of DimSiz The…

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