Oct 1, 2019

The Quick Fix – What is a DBRW formula

It’s inescapable on how important these four characters mean to the product’s integration with Excel.


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.


I want to get data from the ‘Currency Exchange Rates’ Cube.

This is how each parameter for the DBRW will be defined.

TM1ServerName = AdventureWorks

CubeName = Currency Exchange Rates

Element1 = Actual (Version)
Element2 = 2012 (Year)
Element3 = USD (Currency From)
Element4 = AUD (Currency To)
Element5 = Spot Rate (Currency Measure)


DBRW('AdventureWorks':'Currency Exchange Rates', 'Actual', '2012', 'Jan', 'USD', 'AUD', 'Spot Rate');

In Excel.

The same value is also shown in IBM Planning Analytics via the Viewer.

Watch this tutorial on what is a DBRW and how the example above is put together.

If you would like to contact someone to find out more about TM1 and IBM Planning Analytics, email edu@cubewise.com. Head to our End User Training course (link) to learn more great TM1-Excel worksheet functions like the DBRW formula.

Related content

Loading related content