Exploring TM1 - a Chartertech Company
Search
Close this search box.

DBSW TM1 Excel Syntax and Use

The DBSW function in TM1 sends a numeric value to a TM1 cube.  Syntax The syntax for using DBSW function is: Where: The arguments e1 through en are sequence sensitive, meaning the order of the elements is important. e1 corresponds to an element from the first dimension of the cube, e2 corresponds to an element […]

DBR TM1 Excel Syntax and Use

DBR function is used to retrieve a value from a specified TM1 cube. DBR Syntax The syntax for DBR function is as following: Where: A few things to note here regarding the arguments e1 through en: Importance of Sequence in DBR Syntax The sequence of the arguments is crucial. e1 should correspond to an element […]

DBRW TM1 Excel Syntax and Use

DBRW Example

Using DBRW with TM1 in both Perspectives and Planning Analytics for Excel based reports to display the contents of a specific intersection of a TM1 cube.

DBRA TM1 Excel Syntax and Use

Use, Syntax and Example of DBRA with TM1 and Planning Analytics for Excel based reports to display the contents of an Attribute in the Excel sheet.

Log In