How to Get an Element ID from an Alias in a TM1 Rule or Excel Report
Need to get a primary element name from an alias in a TM1 Excel report or TM1 Rule? Simple solution for deriving an element principal name in Rules or Excel.
How to Dynamically Assign Information based on Data Entry
How to create a planning model where users can enter or select variables in one location and TM1 then assigns the data dynamically to all required dimensions. For example, in a budgeting model to plan labour centrally and assign people to cost centres dynamically.
CellGetS TM1 Function: How to Use and Syntax
CellGetS allows you to retrieve a string (text value) from a specific intersection in a TM1 cube for use in a Turbo Integrator (TI) process.
CellGetN TM1 Function: How to Use and Syntax
CellGetN gets a number from a specific intersection of a cube from within a Turbo Integrator process. It can be used as in a similar way to a DB function in a TM1 Rule. Also, don’t confuse it with ‘CellGetS‘ (which retrieves strings) – that just won’t work with numbers! Syntax of CellGetN The syntax is: Where cube is the cube you want to get […]
DB TM1 Function: How to Use, Syntax and Example
The DB rule function in TM1 and Planning Analytics to retrieve the contents (either text or numeric) of a specific intersection of a cube. Similar to CellGetS or CellGetN in a TI process.
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.