Rule Case Studies

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

TM1 Cell Security: How To Do It and Best Practices

Posted on Mar 16, 2022 by Andrew Walker

TM1’s security can be as simple or as complex as you need. We tend to start with the broadest possible definition of security and then refine it down to the…

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

Posted on Dec 18, 2020 by John

We are working with a client where they have a forecasting model that goes out for 10 years by month. It includes labour planning by person, capex, detailed gross profit…

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

Posted on Sep 24, 2020 by John

How do you take a value from one period and roll it to the next in TM1? This is a really simple task in TM1. Why Would you Pull a…

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

Posted on Jun 26, 2020 by John

What? @= in TM1? What does that mean? Well, simply put if you have an expression that says sVariable = ‘Test’; then you are storing the value ‘Test’ into the…

How to Dynamically Assign Information based on Data Entry

Posted on Nov 4, 2019 by John

Have you ever wondered how to have a flat list in TM1 and then send values off to different elements on various dimensions depending on what is entered in the…

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

Posted on Aug 25, 2018 by John

Calculating the number of days in a month is used for a number of financial calculations, such as inventory days and debtor days. Have you ever wondered though how to…

Enabling TM1 Rules via a Control Cube

Posted on Mar 20, 2018 by John

Today we were looking at how we could optimise a client’s rules to improve performance. The first couple of rows of rules were STET rules. In other words, rules that turn on…

Foreign Exchange (FX) Calculation in TM1

Posted on Jul 11, 2017 by John

You may find yourself in a situation where you need to do some basic foreign exchange calculations. In our case, we had a client where we needed to do a…

Limiting a Rule to Active Scenarios Only

Posted on Feb 19, 2016 by John

Today I wanted to update a rule so that the processing of the rule was limited only to those scenarios that are “active”.  I could have gone through each line in the…

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!