Rule Functions

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 SUBSTR function, in that…

SCAN, TM1's FIND function

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 substring…

STET and CONTINUE in TM1

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 the current intersection. This is really useful to place at the top of the rules 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: How to Use, Syntax & 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.

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 numeric) of a specific intersection of a cube. Similar to CellGetS or CellGetN in a TI process.

NUMBR TM1 Function: Use and Syntax

NUMBR Function for use in Rules and TI Processes in TM1 and Planning Analytics to convert a string of text to a value in the same way the Value function works in an Excel formula. Fully explained with examples.

Attributes String

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 retrieve the value of a string attribute.

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 element is an ancestor of another. In other words, if one element is higher in a hierarchy than another element.

3 Types of TM1 Rules All Developers Should Know

Here we discuss how to do three rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There are full explanations and the code used for the rule examples.

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