Tag Archives: Rules

Over Feeding in TM1 – What is it and How to Avoid it

Overfeeding is where TM1 feeders are targetting more cells than are required. This can lead to excess memory consumption and reduce performance. Here we explain over feeding and how to avoid it.

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 where the evaluated value changes from a zero to a non-zero value and the fed cell does not get initiated and therefore the rule does not calculate. Background on Feeders As you would undoubtedly be aware, TM1 is an in memory application and extremely efficient with utilising that memory. It is also … Continue Reading

Indenting TI Processes and Rules in TM1

How to use indents to layout Rules and Turbo Integrator processes in TM1 so they are easier to read.

Notepad++ for TM1 Rules & TI – Updated!

With the new release of Notepad++ yesterday to v6.4.1, I thought it was a brilliant time to update the TM1 Turbo Integrator and Rules Syntax files to be based on TM1 v10.1.0 Reference Guide. The new version xml file can be found here: TM1 v10.1 Notepad++ update In this release, we’ve added a couple of new TI functions such as: Synchronize: Used in a TI script to force serial execution of … Continue Reading

Adding Financial Local/Group Currency Logic

The purpose of this article is to describe how to add a Local/Group Currency system to a new TM1 cube; this can be core requirement for International Companies and is relatively common. To explain the Group/Local split, Group – the company’s home country currency – used primarily for Reporting Local – the branch/profit-centre’s currency – how data is entered.

Naming Conventions and Syntax

Within TM1 all objects names and contents are completely defined by the Developer. Cubes, Public Views, Dimensions, Public Subsets, Processes, Chores and Applications are all named on creation. All too often naming conventions are disregarded within the initial development stages of a TM1 implementation. Usually an attempt is made to bring these in at a later time, often too late – it will  never be considered as a value-add enhancement … Continue Reading

Conditional Feeders

Conditional feeders can be used to minimize the storage impact of rule feeders. The typical situation occurs when rule values are calculated by multiplying factors, any of which may be zero. This means that the value should be fed only when all the factors are non-zero. Example Given a cube SalesBySalesperson with dimensions: Salesperson, Product, Month, Measures (‘Sales’ and ‘Commissions’) If you calculate Commissions based on Sales using a commission … Continue Reading