Exploring TM1 - a Chartertech Company
Search
Search
Close this search box.

Rule Best Practices

Feeders
John Vaughan

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.

Read More »
Foreign Exchange in TM1
Rule Best Practices
John Vaughan

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.

Read More »
STET and CONTINUE in TM1
Rule Best Practices
John Vaughan

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.

Read More »

Empty Square Brackets in a TM1 Rule

Ever wondered why some TM1 rules have empty square brackets (like this [ ] )? Well MafiaMan just explained it to me.  Really simple, but also extraordinarily powerful.  What it means is

Read More »

Back to Basics – Regions in Rules

If there is one basic technical best practise which makes TM1 Solutions more straight-forward thus sustainable which is most often not utilised it is #Regions in cube rules. Regions work the same way as

Read More »
Feeders
Ben Hill

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.

Read More »

Log In