ATTRS

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.

Attributes, Rule Best Practices, Rule Case Studies

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.

Elements, Rule Functions, TI Functions

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.

Rule Best Practices, Rule Case Studies

How to Accumulate Values in TM1 for Rolling Forecast or Cashflow

Excel Functions

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.

Attributes, Rule Functions, TI Functions

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.

Feeders, Rule Best Practices, Rule Case Studies, Rule Functions

3 Types of 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.

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement