Rules

Feeders, Rule Best Practices

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.
Feeders, TM1 Performance, tm1s.cfg

Persistent Feeders in TM1 – Speed-Up Model Restarts

Persistent Feeders can dramatically decrease the time required to restart a TM1 model. Here is an explanation of what Persistent Feeders are and instructions on how to implement them in your TM1 model.
Attributes, Rule Best Practices, Rule Case Studies

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.
Feeders, TM1 Performance

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.
Rule Functions, TI Functions

DType Function in TM1: Syntax and Use

Use, syntax and example of the DType function in TM1 and Planning Analytics. In this post we explain the use of the DType function and give an example of how it can be used to determine the cell type of a cube when loading data via a Turbo Integrator process.
Rule Case Studies

Enabling TM1 Rules via a Control Cube

A simple solution to enabling and disabling rules for different versions (or scenarios) using either an attribute on the Version dimension or a simple cube, intersecting the }Cube and Version dimensions.
Rule Functions, TI Functions

MONTH Function in TM1: Syntax and Use

The MONTH function in TM1 allows us to extract the number representing the Month from a date. Here we explain it’s syntax and give an example combining it with the DATE function.

Rule Functions, TI Functions

How to Convert a Numeric Date to a String using the DATE Function in TM1

The Date Function in TM1 converts a serial date from a number to a string. For example Date(13947 , 1); will return the string ‘1998-03-09’.
Foreign Exchange in TM1
Rule Best Practices, Rule Case Studies

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.
Excel Functions, Rule Errors

Errors Connecting to Planning Analytics for Excel/CAFE

Launching CAFE or Planning Analytics for Excel (PAX) can cause errors if the PC is not configured to conform to IBM’s supported environment. Here we run through how to get it all sorted!

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

Subscribe Now