Tag Archives: CellGetS

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.

DatasourceNameForServer and DatasourceNameForClient TM1 Functions: Use and Syntax

Ever wondered how you can vary the data source for a Turbo Integrator process inside the actual process so it becomes dynamic? Well here is a method. Firstly, define a bunch of variables: sCurrentMonth = CellGetS ( ‘System Assumptions’, ‘No Year’, ‘No Month’, ‘Current Month’, ‘String’ ); sFileDir = ‘\\servername\folder\’; sFileName = sCurrentMonth | ‘ ‘ | SUBST(sCurrentYear,3,2) | ‘ Employees.csv’; sFilePath = sFileDir | sFileName; Then use DatasourceNameForServer and DatasourceNameForClient to … Continue Reading

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.