DBR
DBR retrieves a value from a specified TM1® cube.
In IBM® Planning Analytics for Microsoft Excel, the DBR function is equivalent to the DBRW function. Both functions are optimized to reduce network traffic and improve performance on wide area networks.
When all member arguments (m1, m2, etc.) to the function are leaf members, you can use the DBR function to write values to the specified cube, provided that you have the appropriate access privileges to the relevant cube, dimensions, members, and/or cells.
You can modify the members used in a DBR or DBRW function using the DBR Function Editor. For more information, see Modify functions by using the Function Editor.
Syntax
DBR(server:cube, m1, m2,[...mn])| Argument | Description | Required/Optional |
|---|---|---|
|
server:cube |
The name of a TM1 Server Application folder and the name of a cube that is available on the server. |
Required |
|
m1,...mn |
Dimension member names that define the intersection of the cube containing the value to be retrieved. Arguments m1 through mn are sequence-sensitive. m1 must be a member from the first dimension of the cube, m2 must be a member from the second dimension, and so on. These arguments can also be the names of aliases for dimension members. Numeric member names must be enclosed in double quotation marks. |
Required |
Example
In this example, the TM1 Server Application folder 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.DBR("GO_New_Stores:Base Sales Forecast", "Americas", "Department Store",
"Freight", "Corporate Store", "Budget version 1", "Jan")