Top 10 TM1 Rule Functions

We ran a survey to identify the Top 10 TM1 Rule functions. The results are interesting, and, dare I say it a little surprising!

Here’s the results and links to each of the posts explaining their use below.

01.

Rule Best Practices | Rule Functions

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...

johnv Vaughan

4 min read

Read

02.

Attributes | Dimensions | Rule Functions | Rules | TI Functions | Turbo Integrator

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...

johnv Vaughan

2 min read

Read

03.

Elements | Rule Functions | TI Functions

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...

johnv Vaughan

2 min read

Read

04.

Rule Functions | Rules | TI Functions | Turbo Integrator

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

The SUBST function is essentially the same as the Excel MID function or the SQL Server...

johnv Vaughan

2 min read

Read

05.

Rule Functions | Rules | TI Functions | Turbo Integrator

Scan TM1 Function: How to Use, Syntax and Examples

Scan is a TM1 function that finds the numeric position of the first instance of a specified...

johnv Vaughan

2 min read

Read

06.

Rule Best Practices | Rule Functions | Rules

How to Use STET and CONTINUE in TM1 Rules

Using STET and CONTINUE in TM1 rules to indicate if the rule sheet should continue to execute for...

johnv Vaughan

3 min read

Read

07.

Excel Functions | Rule Functions | TI Functions

ELPAR TM1 Function: How to Use and Syntax

ELPAR is a TM1 worksheet function for showing the parent value of an element. This explains the...

johnv Vaughan

2 min read

Read

08.

Rule Functions | Rules | TI Functions | Turbo Integrator

DIMIX TM1 Function: How to Use, Syntax & Examples

An in depth explanation of the usage of the DIMIX Function in Turbo Integrator Processes and Rules...

johnv Vaughan

2 min read

Read

09.

Rule Functions | Rules | TI Functions | Turbo Integrator

ELISANC TM1 Function: How to Use, Syntax and Example

ELISANC Function for use in Rules and TI Processes in TM1 and Planning Analytics to test if one...

johnv Vaughan

2 min read

Read

10.

Rule Functions | Rules

DB TM1 Function: How to Use, Syntax and Example

The DB rule function in TM1 and Planning Analytics to retrieve the contents (either text or...

johnv Vaughan

2 min read

Read

11.

Attributes | Dimensions | Rule Functions | Rules | TI Functions | Turbo Integrator

ATTRS TM1 Function: How to Use and Syntax within TI and Rules

ATTRS Function for use in Rules and Turbo Integrator Processes in TM1 and Planning Analytics to...

johnv Vaughan

1 min read

Read