Rule Case Studies

Rule Case Studies, Security

TM1 Cell Security: How To Do It and Best Practices

TM1’s security can be as simple or as complex as you need. We tend to start with the…

Rule Case Studies

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.

Rule Best Practices, Rule Case Studies

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.

Rule Case Studies, TI Case Studies

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

Feeders, Rule Best Practices, Rule Case Studies, Rule Functions

How to Dynamically Assign Information based on Data Entry

How to create a planning model where users can enter or select variables in one location and TM1 then assigns the data dynamically to all required dimensions. For example, in a budgeting model to plan labour centrally and assign people to cost centres dynamically.

Attributes, Rule Best Practices, Rule Case Studies

Days in Month – How to Easily Calculate in a TM1 Rule

Here we explain how to calculate the number of days in each month with a simple, but easy rule, using the DAYNO function and a Next Month attribute.

Rule Case Studies

Enabling TM1 Rules via a Control Cube

A simple solution to enabling and disabling rules for different versions (or scenarios) using either an attribute on the Version dimension or a simple cube, intersecting the }Cube and Version dimensions.

Rule Best Practices, Rule Case Studies

Foreign Exchange (FX) Calculation in TM1

Simple foreign exchange conversion method for use in TM1. Convert multiple currencies to multiple currencies easily using a simple FX rates cube and lookup of a cost centre or entity.

Rule Best Practices, Rule Case Studies