DBRW

DBRW retrieves a value from a specified TM1® cube.

In IBM® Planning Analytics for Microsoft Excel, the DBRW function is equivalent to the DBR function. Both functions are optimized to reduce network traffic and improve performance on wide area networks. For more information, see DBR.

Example

In this example, the TM1 server name is GO_New_Stores and the cube name is Base Sales Forecast. The function returns the value at the intersection of Americas, Department Store, Freight, Corporate Store, Budget version 1, and Jan.
DBRW("GO_New_Stores:Base Sales Forecast", "Americas", 
"Department Store", "Freight", "Corporate Store", "Budget version 1", "Jan")