Rule Best Practices

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.

Cascading Picklists in TM1 – How to Create in 4 Steps

Posted on Aug 3, 2021 by John

Have you ever wanted a user to select one item from a picklist (or dropdown) and then have a subsequent picklist update to only show valid selections based upon what…

Calculating “As At” Values in a TM1 Rule

Posted on Apr 21, 2021 by Andrew Walker

Have you ever needed to calculate the value “as at” a point in time? For example, you have an inventory cube and want to show the volume of stock at…

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…

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…

Feeding from a Consolidation to a Leaf Element in TM1

Posted on Feb 19, 2019 by John

We are working with a client to create a rolling forecast model. As part of this we are using a concept called Planning Accounts. These are aggregates of general ledger…

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) 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…

How to use 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 an 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…

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…

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!