TM1 Function for Excel, DBR

DBR retrieves and writes back a value or text to a cube’s cell. DBR is less efficient over a WAN than DBRW. DBR will be processed before a DBRW

Where can the DBR function be used?

Excel

Which TM1 Server version is this function available for?

Version 11 and 12

What is the DBR function?

DBR retrieves and writes back a value or text to a cube’s cell. DBR is less efficient over a WAN than DBRW. DBR will be processed before a DBRW.

What is the syntax for DBR?

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

Obtain the Actual value for each Product Type from the Product Scorecard Cube. Firstly, in the demo we will show the static values. Then these will be changed to dynamic values using ‘$’ to make the cell reference absolute. This is advantageous because when the formula is copied to other cells the formula will reference the correct items.