3 Types of TM1 Rules All Developers Should Know

We’ve gone through our training notes and aside from basic equation rules, we've listed three types of common TM1 rules which every developer should be familiar with. If you haven’t ever had to write one of these rules before, you should try it. It will be good practice because we’ve all seen [‘Sales $’] = N: [‘Units’] * [‘Price’] example far too many times!

We’ve boiled it down to 3 types of rules which every consultant should know:

  • Allocation/Phase/Spread Rule – e.g. Allocate/phase/spread our budgeted sales across States based on the Actual Sales ratio.
  • Rolling Value Rule – e.g. Opening (Measure) is equal to the Closing of the prior period. Often used in the Balance Sheet or Depreciation rules.
  • Averaging Rule (C Level) – e.g. Averaging Percentages or Rates up all hierarchies within the cube.

As with TM1, and Platform Software in general, there are a million ways to do anything, so don’t worry if we don’t follow the methodology you are familiar with. That being said, these 3 TM1 rules are a great guide for any developer!


Sorry about this, but you don't have permission to view this page! Make sure you're logged in and try again or contact us for help.

Cheers, John and the ExploringTM1 Team