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
Excel
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.
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.
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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book