Category Archives: Rule Examples

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

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

String Rules

I went to create a rule to calculate some string rules today and I kept getting a rule error saying that I had an invalid expression. Thankfully the solution was pretty easy! Situation I have a cube where I have an element that indicates if a set of days are to be included in a forecast inventory calculation or not. I could have combined all of this into a complex rule, however … Continue Reading

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

Deriving an Element from an Alias in TM1

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

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

Limiting a Rule to Active Scenarios Only

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

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

Accumulating Values for a Rolling Forecast

Mmmm.  Hard one.  How do I take a value and then use it for all periods from now on in a Rolling Forecast environment.  For example, I have a change I want to apply to a rate that is then to be used from now until the end of the rolling forecast. Year 2014 2015 Month Oct Nov Dec Jan Feb Mar Price             100             100             100             … Continue Reading

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

Empty Square Brackets in a TM1 Rule

Ever wondered why some TM1 rules have empty square brackets (like this [ ] )? Well MafiaMan just explained it to me.  Really simple, but also extraordinarily powerful.  What it means is that the all intersections of a cube are impacted by the rule. For example.  We wanted to limit the use of a set of rules to the children only of part of the business structure.  So we created a rule … Continue Reading

This entry was posted in Rule Examples. Bookmark the permalink. | 1 Comment