Tag Archives: DB

How to Dynamically Assign Data based on Selection in a Planning Model

How to create a planning model where users can enter and select variables in one location and TM1 then assigns the data dynamically to all required dimensions.

CellGetS TM1 Function: 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: Use and Syntax

CellGetN gets a string 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: CellGetN (Cube, element1, element2, elementn ); Where cube is the cube you want to get a number from element1 is an element from the first dimension … Continue Reading

DB TM1 Function: Use and Syntax

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.

3 Types of Rules TM1 Developers Should Know

In this blog we discuss how to do three different rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There is full explanations and the code used for the rule examples.