# TM1 Function for Excel, DBRW

##### DBRW is one of the key TM1 and Planning Analytics formulas that provides read and write back capability to Excel from a Cube.

Where can the DBRW function be used?

Excel

What is the DBRW function?

DBRW is one of the key TM1 and Planning Analytics formulas that provides read and write back capability to Excel from a Cube.

What is the syntax for DBRW?

DBRW(TM1ServerName:CubeName, Element1, Element2, Element3, …, ElementN)
TM1ServerName = Name of the TM1 Server
CubeName = Name of the Cube
Element1 to ElementN = An element in each dimension from the Cube. Each element must be ordered based on the dimension for the Cube.

A demonstration on how to use DBRW

Retrieve a cell from the Product Scorecard cube using the DBRW formula. The DBRW references are