Rule Examples

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.

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…

Foreign Exchange (FX) Translation in TM1

Posted on Jul 11, 2017 by John

We have a client where we needed to do some basic foreign exchange translation. It was a simple FX translation of New Zealand Dollars to Australian Dollars and then to…

Operators in TM1 Rule IF Statements

Posted on Mar 22, 2017 by John

Do you need to create an IF expression in a TM1 rule with a logical operator? To create something that is like and AND or OR from SQL but do…

CubeProcessFeeders – Forcing TM1 to Reprocess Feeders

Posted on Oct 11, 2016 by John

In the rules for many cubes we work with there are conditional feeders. These often cause us problems where the evaluated value changes from a zero to a non-zero value…

Ambiguous Element Name: TM1 Rule Error

Posted on Jun 9, 2016 by John

I recently opened a rule and made a very minor change, then wend to save it and got a really odd error that had nothing to do with the changes…

String Rules

Posted on May 9, 2016 by John

I went to create a rule to calculate some string rules today and I kept getting a rule error saying that I had an invalid expression. Thankfully the solution was pretty…

Deriving an Element from an Alias in TM1

Posted on May 9, 2016 by John

Today I needed to look up an element name from an alias. The solution involved combining the use of Dimix and DimNm. Problem The situation was that I have 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…

Accumulating Values in TM1 for Rolling Forecast/Cashflow

Posted on Feb 27, 2015 by John

How do I take a value and then use it for all periods from now on in a Rolling Forecast environment?  In other words, how do I accumulate (or calculate…

Empty Square Brackets in a TM1 Rule

Posted on Oct 26, 2014 by John

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…

Need help with TM1?
We're here for you



Keen to chat? Book a discovery call!