Tag Archives: CellGetS

CellGetS TM1 Function: Use and Syntax

CellGetS 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 ‘GetCellN’ (which retrieves numbers) – that just won’t work with strings! Syntax of CellGetS The syntax is CellGetS (Cube, element1, element2, elementn ); where cube is the cube you want to get a number from element1 is an element from the … Continue Reading

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 ‘GetCellS’ (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 of … 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.

/* THIS WAS THE CODE USED FOR EMBEDDING A SURVEYMONKEY POPUP */