‘@= in TM1: How to Use it in Rules and Processes
‘@= is used in TM1 for evaluation of operators in TM1 Rules and TI Processes. Here we explain how it is used and give examples for both rules and processes.
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.
How to use 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
Forcing TM1 to reprocess Feeders using CubeProcessFeeders on a cube with Conditional Feeders in a TI process. Why used, Syntax and Examples.
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.
Finding the Rules Editor in Cognos Insight
I was tasked to draft up something on Cognos Insight. Without going through the Cognos Insight user guide, I have got stuck when trying to link data between cubes. “How I do edit rules in Insight?”, I asked. Until I have got a reply from a colleague, “Look for the widget toolbars!”. Have you ever […]
Notepad++ for TM1 Rules & TI – Download – Updated!
Here is a downloadable Notepad++ language file for TM1 and Plannign Analytics. Use it to view syntax of TM1 Rules and Turbo Integrator processes in Notepad++.
Back to Basics – Regions in Rules
If there is one basic technical best practise which makes TM1 Solutions more straight-forward thus sustainable which is most often not utilised it is #Regions in cube rules. Regions work the same way as grouping rows within Microsoft Excel, except the grouping is done automatically around a set of key words. This is actually a feature in many scripting environments and […]
Rolling Forecasts in IBM Cognos TM1
Recently, a client has asked to implement a rolling forecast model to move towards a more dynamic way of forecasting. With this as periods move forward so does your forecast. In this way you are always forecasting 12 / 18 months out in to the future. What is a Rolling Forecast With a rolling forecast […]
Three TM1 Rules All Developers Should Know
Here we discuss how to do three rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There are full explanations and the code used for the rule examples.
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 – […]
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 […]
Conditional Feeders in TM1 Made Easy with Examples
Conditional feeders can be used to minimise the save time and storage impact of feeders. This post goes through the various ways to utilise conditional feeders and workaround to issues that can arise implementing them.