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

Excel Functions

Excel Functions
Rehmat Walia

TM1USER TM1 Excel Syntax and Use

TM1User function, when used in Planning Analytics for Excel, returns the user logged in the current server. TM1USER SYNTAX The syntax is as following: Where: Example and Usage To provide

Read More »
Excel Functions
Rehmat Walia

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,

Read More »
Excel Functions
Rehmat Walia

DBS TM1 Excel Syntax and Use

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

Read More »
Excel Functions
Rehmat Walia

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

Read More »
Excel Functions
Rehmat Walia

VIEW TM1 Excel Syntax and Use

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

Read More »
Excel Functions
Rehmat Walia

DBSS TM1 Excel Syntax and Use

The DBSS function sends a string value to any TM1 cube’s cell. DBSS Syntax The syntax for DBSS is: Where: Importance of Sequence It is important to note that the

Read More »
Excel Functions
Rehmat Walia

DBSA TM1 Excel Syntax and Use

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: Where: Example of

Read More »
Excel Functions
John Vaughan

Dynamic TM1 Server Name in Excel Workbook

Dynamically refer to the current TM1 server with the TM1PRIMARYDBNAME Excel function. It will mean all your server references in TM1 formulas will dynamically update and refer the model you are currently logged into.

Read More »
Excel Functions
John Vaughan

Create a TM1 Send Sheet in Excel

Excel based TM1 Send Sheets are a wonderful way of having data that is calculated in Excel loaded automatically into TM1 on demand. Here we show how to create a send sheet and automate it so that it only runs when required.

Read More »
DBRW Example
Dynamic Reports
John Vaughan

DBRW TM1 Excel Syntax and Use

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.

Read More »

Display TM1 Attributes in Excel

Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1 attribute in an Excel report is to use a DBRW, DBR or DBRA

Read More »