Rules

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.

DATE Function in TM1: Syntax and Use

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

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.

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!

Operators in TM1 Rule IF Statements

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

TM1/Cognos Security Integration Gremlin

Weird. That’s all I can say. We have been doing a significant project with complex calculations done in…

Skipcheck Article

What is Skipcheck in TM1?

Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. For…

Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule

I was asked the other day how to concatenate some information in TM1. Joining two text fields is really…

CubeProcessFeeders – Forcing TM1 to Reprocess Feeders

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

TI Connection Error to Cognos BI Report

We sometimes recommend using a Cognos BI Package and BI report as the source for TM1. We usually…

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