Category Archives: 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.

This entry was posted in Rule Functions, TI Functions and tagged Date, Dates, Month. Bookmark the permalink. | Tagged Date, Dates, Month | Leave a comment

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’.

This entry was posted in Rule Functions, TI Functions and tagged Date. Bookmark the permalink. | Tagged Date | Leave a comment

Foreign Exchange (FX) Translation in TM1

Simple foreign exchange translation 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.

This entry was posted in Rule Examples and tagged currencies, foreign exchange, fx. Bookmark the permalink. | Tagged currencies, foreign exchange, fx | Leave a comment

Operators in TM1 Rule IF Statements

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

This entry was posted in Rule Examples, Rule Functions and tagged IF, operators, Rules. Bookmark the permalink. | Tagged IF, operators, Rules | Leave a comment

What is Skipcheck in TM1?

Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. So if you had 30 days in a month and data in only 9 of them, only 9 cells would be aggregated to get the total for the month. With the the skipping of blank cells disabled, all 30 cells would be checked to get the month total – three times more inefficient. … Continue Reading

This entry was posted in Feeders, Rule Functions and tagged skipcheck. Bookmark the permalink. | Tagged skipcheck | 1 Comment

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 easy!  Just use the pipe ( ” | ” ) between two variables and they will joined into one. There is nothing like the Excel Concatenate function in TM1. How to Concatenate Let’s say you have variable 1, sVariable1 = ‘Exploring’; and sVariable2 = ‘TM1’; then using sOutput = sVariable1 | sVariable2; will … Continue Reading

This entry was posted in Rule Functions, TI Functions and tagged concatenate, concatenation. Bookmark the permalink. | Tagged concatenate, concatenation | Leave a comment

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

This entry was posted in Feeders, Rule Examples, TI Functions and tagged Conditional Feeders, cubeprocessfeeders, Feeders, Rules. Bookmark the permalink. | Tagged Conditional Feeders, cubeprocessfeeders, Feeders, Rules | Leave a comment

Ambiguous Element Name: TM1 Rule Error

I recently opened a rule and made a very minor change, then wend to save it and got a really odd error that had nothing to do with the changes I had made to the rule. The error said “Error: Element name ambiguous ‘Current Year’”. This seemed rather odd as had not made any changes that had anything to do with time. Then I remembered that I had added an … Continue Reading

This entry was posted in Errors, Rule Examples. Bookmark the permalink. | Leave a comment

TODAY TM1 Function: Syntax and Use

TODAY simply returns the current system date as a string in the form ‘yy-mm-dd’, or if you want, in the format ‘yyyy-mm-dd’. Syntax of TODAY The syntax is Today ( FourDigitYearFlag); where: FourDigitYearFlag – can be either omitted or 0 or 1, where omitted or 0 will return the 2 digit year and a 1 will return a 4 digit year. Example Assuming the current system date is 07 June … Continue Reading

This entry was posted in Rule Functions, TI Functions and tagged today. Bookmark the permalink. | Tagged today | Leave a comment

STR TM1 Function: Syntax and Use

STR is a TM1 function that converts a number to string. It is very similar to the Excel function “TEXT”, except you don’t need to specify the format of the output. If you are looking for the command to convert a string into a number, please see the Numbr function. Syntax of STR STR (number, length, decimal); where: number – the actual number you want to convert, length – the length of … Continue Reading

This entry was posted in Rule Functions, TI Functions. Bookmark the permalink. | Leave a comment