Rehmat Walia

TM1User function, when used in Planning Analytics for Excel, returns the user logged in the current server. TM1USER SYNTAX The syntax is as following: TM1User(“ServerName”) Where: ServerName : The name…

The DBSW function in TM1 sends a numeric value to a TM1 cube.  Syntax The syntax for using DBSW function is: DBSW(value, cube, e1, e2[,…en]) Where: Value: The numeric value…

DBS is an Excel based function, used to send numeric values to a TM1 cube’s cell. Example To illustrate the usage of DBS, let’s consider a Sales Analysis cube with…

DBR function is used to retrieve a value from a specified TM1 cube. DBR Syntax The syntax for DBR function is as following: DBR(server:cube, e1, e2,[…en]) Where: server:cube: name of…

The VIEW function enhances the efficiency of a Planning Analytics for Excel Custom Reports or Dynamic Reports by establishing an optimised representation of a cube. This feature speeds up report…

The DBSS function sends a string value to any TM1 cube’s cell. DBSS Syntax The syntax for DBSS is: DBSS (string, cube, e1, e2,…en) Where: string: The string value that…

DBSA allows you to send a value (numeric or string) to an attribute of an element in a dimension. DBSA Syntax The syntax for this function is: DBSA(attribute_value, dimension, element,…