## 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.

**DBRW****A demonstration on how to use**Retrieve a cell from the **Product Scorecard **cube using the DBRW formula. The DBRW references are

TM1 server name = AdventureWorks

Cube name = Product Scorecard

Element in 1^{st} Dimension (Version) = Actual

Element in 2^{nd} Dimension (Year) = 2020

Element in 3^{rd} Dimension (Quarter) = Q1

Element in 4^{th} Dimension (Product Type) = Bike Racks

Element in 5^{th} Dimension (Product Scorecard) = Sales Amount

Element in 6^{th} Dimension (Product Scorecard Measure) = Value