Tag Archives: Rules

Operators in TM1 Rule IF Statements

Do you need to create an IF expression in a TM1 rule with a logical operator? To create something that is like and AND or OR from SQL but do it in a Rule? Look no further! If, however, you are looking for IF operators for a Turbo Integrator process, please check this post. TM1 Rule Operators There are some very useful operators available in TM1 Rules. Use For OR, … Continue Reading

This entry was posted in Rule Examples, Rule Functions and tagged IF, operators, Rules. Bookmark the permalink. | Tagged IF, operators, Rules | 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

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

This entry was posted in Code Sample - Downloadable, Cognos Express, TM1 10.1, TM1 pre 10.1, Training Material and tagged Code, IBM Cognos Express, IBM Cognos TM1, Notepad++, Rules, Syntax Highlighting, Turbo Integrator. Bookmark the permalink. | Tagged Code, IBM Cognos Express, IBM Cognos TM1, Notepad++, Rules, Syntax Highlighting, Turbo Integrator | 10 Comments

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.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Currency, Currency Conversion, Forex, Group Currency, Local Currency, Rules, TM1. Bookmark the permalink. | Tagged Currency, Currency Conversion, Forex, Group Currency, Local Currency, Rules, TM1 | Leave a comment

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

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Best Practice, ETL, Rules, TM1Naming Conventions, Turbo Integrator. Bookmark the permalink. | Tagged Best Practice, ETL, Rules, TM1Naming Conventions, Turbo Integrator | Leave a comment

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

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Conditional Feeders, Feeders, Rules. Bookmark the permalink. | Tagged Conditional Feeders, Feeders, Rules | Leave a comment