Rules

DAY TM1 Function: How to Use, Syntax and Example

The TM1 DAY function extracts the Day of Month number from a string based date. For example, DAY (’21-09-18′) will return the number 18.

Cascading Picklists in TM1 – How to Create in 4 Steps

Cascading Picklists in TM1 are a great way to limit long lists from being displayed to users for selection. Here we explain exactly how to create them.

ELCOMP TM1

ELCOMP TM1 Function: How to Use and Syntax

In TM1, ELCOMP returns the child element at a specified numeric position of a parent. Full syntax and explanation for use.

ELCOMPN TM1 Function: Syntax and Use

In TM1 and Planning Analytics, ELCOMPN returns the number of children an element has Full syntax and explanation for use.

Calculating “As At” Values in a TM1 Rule

Have you ever needed to calculate the value “as at” a point in time? For example, you have…

TM1 FEEDSTRINGS: What Is It and How Do You Use It

You’ve probably have across a rule that has SKIPCHECK at the start. You might have noticed that also,…

How to Limit TM1 Rule Scope (and speed up your model!)

Simple method for cutting down the calculation overhead of TM1 rules for a multi year forecasting model by limiting rule scope.

Roll Forward

How to Roll Forward Values from One Period to the Next in TM1

Accumulating values in TM1 over multiple years. Cumulative values are very useful in a rolling forecast or cash flow calculation model. This shows in detail how to create a cumulative values with colour coded examples.

ELISPAR TM1 Function: Use and Syntax

ELISPAR tests if an element is a direct child of a parent in a dimension in TM1. Here we explain how to use it, provide examples and compare it to ELISANC.

Use of @= in TM1

@= in TM1: How to Use it in Rules and Processes

@= is used in TM1 for evaluation of operators in TM1 Rules and TI Processes. Here we explain how it is used and give examples for both rules and processes.

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