Cubewise Code
ProductsServicesResourcesDownloadsSupportEducationCompany
Contact us
global-search

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 1st Dimension (Version) = Actual
Element in 2nd Dimension (Year) = 2020
Element in 3rd Dimension (Quarter) = Q1
Element in 4th Dimension (Product Type) = Bike Racks
Element in 5th Dimension (Product Scorecard) = Sales Amount
Element in 6th Dimension (Product Scorecard Measure) = Value