Rule Best Practices

Cascading Picklists in TM1 – How to Create in 4 Steps

Cascading Picklists in TM1 are a great way to limit long lists from being displayed to users for selection. Here we explain exactly how to create them.

Calculating “As At” Values in a TM1 Rule

Have you ever needed to calculate the value “as at” a point in time? For example, you have…

Roll Forward

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.

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.

Feeding from a Consolidation to a Leaf Element in TM1

How, in TM1/Planning Analytics, to feed from a consolidated element in one cube to a leaf element in another cube using a single consolidation feeder with a worked example.

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.

Foreign Exchange in TM1

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.

Operators in TM1 Rule IF Statements

Explanation and Example of “AND” and “OR” Operators in IF statements in TM1 Rules.

CubeProcessFeeders – Forcing TM1 to Reprocess Feeders

In the rules for many cubes we work with there are conditional feeders. These often cause us problems…

Deriving an Element from an Alias in TM1

How do you derive an element ID from an alias or attribute in TM1?

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement