The Quick Fix – What is a DBRW formula

DBRW is one of the key TM1 and Planning Analytics formulas that provides read and write back capability to Excel for the functional database. We can thank the inventor of TM1, Manny Perez for this clever idea.

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

Syntax

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.

Example

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)

RESULT

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.

Leave a Reply

Your email address will not be published. Required fields are marked *