Rule Functions

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…

DimSiz TM1 Function: Use and Syntax

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

SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): Use and Syntax

The SUBST function is essentially the same as the Excel MID function or the SQL Server SUBSTR function, in that…

SCAN, TM1's FIND function

Scan TM1 Function: Syntax and Use

Scan is a TM1 function that find the numeric position of the first instance of a specified substring…

STET and CONTINUE in TM1

Using STET and CONTINUE in TM1 Rules

Using STET and CONTINUE in TM1 rules to indicate if the rule sheet should continue to execute for the current intersection. This is really useful to place at the top of a rule sheet to limit what intersections are calculated.

NOW() TM1 Function: Syntax and Use

The now() function returns a value corresponding with the number of days from either 1 January 1960 or 1 January 1900. It’s the same as the Excel now() function.

TM1 DIMIX

DIMIX TM1 Function: Use, Syntax and Examples

An in depth explanation of the usage of the DIMIX Function in Turbo Integrator Processes and Rules in TM1 and Planning Analytics. In short, to assess if a variable exists as either an element or an alias in a TM1 dimension.

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