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