How to Roll Forward Values from One Period to the Next in TM1
Accumulating values in TM1 over multiple years. Cumulative values are very useful in a rolling forecast or cash flow calculation model. This shows in detail how to create a cumulative values with colour coded examples.
Days in Month – How to Easily Calculate in a TM1 Rule
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.
How to Find the Level of an Element in TM1: ELLEV Use and Syntax
Syntax and Use of ELLEV in TM1 and Planning Analytics to determine the level of a particular element from a dimension.
How to Accumulate Values in TM1 for Rolling Forecast or Cashflow
Accumulating values in TM1 over multiple years. Cumulative values are very useful in a rolling forecast or cash flow calculation model. This shows in detail how to create a cumulative values with colour coded examples.
ELPAR TM1 Function: How to Use and Syntax
ELPAR is a TM1 worksheet function for showing the parent value of an element. This explains the syntax and use of ELPAR, however it is better to use ATTRS.
ATTRS TM1 Function: How to Use and Syntax within TI and Rules
ATTRS Function for use in Rules and Turbo Integrator Processes in TM1 and Planning Analytics to retrieve the value of a string attribute.
Three TM1 Rules All Developers Should Know
Here we discuss how to do three rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There are full explanations and the code used for the rule examples.