Category Archives: Rule Examples
How to create a planning model where users can enter and select variables in one location and TM1 then assigns the data dynamically to all required dimensions.
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.
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.
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.
Explanation and Example of “AND” and “OR” Operators in IF statements in TM1 Rules.
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
Saving a TM1 rule and getting an error “element name ambiguous”? Here is how to fix it and the trick the other posts on the internet fail to tell you about!
What do you do when you get an ‘invalid expression’ error when saving a rule based on a string element? This post dives into the best way to solve this error message with an example of the correct syntax.
Today I needed to look up an element name from an alias. The solution involved combining the use of Dimix and DimNm. Problem The situation was that I have a System Settings cube which derives the date and subsequently the year, month and day from the date. The month is string and in the form “03”. I wanted to add an element that is also string that shows the month … Continue Reading
Today I wanted to update a rule so that the processing of the rule was limited only to those scenarios that are “active”. I could have gone through each line in the rules and added specific references to the scenarios I want to be active in the scope of each line of the rules. What I wanted was to limit rules to work only on specific scenarios. I then thought of this. If … Continue Reading