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