DBRW function#

DBR and DBRW retrieve a single cube cell value at the intersection of one element per dimension. In Reportworq the two names are the same function; DBRW (the "register" variant) is the one used in most live grids. This is the everyday way to pull one Planning Analytics number into a cell.

DBR and DBRW are native TM1 / Planning Analytics functions; Reportworq evaluates them against the workbook's TM1 connection at report-generation time.

Signature#

=DBRW("Server:Cube", element1, element2, ... elementN)
=DBRW("Server:Cube:ViewID", ...)      // the form used inside an Active Form

Arguments#

You must supply at least two arguments; if the second argument is not a list, a third is required. The element count is re-checked against the cube's real dimension count when the report runs.

What happens when an argument is wrong#

Reportworq reports a bad argument as a hard error (the cell shows #VALUE!), a warning (a message in the run report while the cell falls back to blank), or a silent drop. Several of these depend on the connection's Calc Mode; see how Reportworq handles errors.

Notes and limits#

• Retrieval is deferred. Outside write-back the cell briefly shows #VALUE! while Reportworq batches the value, then resolves it. Inside an Active Form that has not yet expanded, the cell returns blank. This is normal timing, not an error.
• To write a value back to a cube cell, use DBS.

Examples#

=DBRW("PlanTM1:Sales", "Northeast", "Widget", "Jan", "Revenue")
=DBRW("PlanTM1:Sales", $B$2, $B$3, $B$4, "Revenue")

Related pages#

• IBM Planning Analytics functions - the function index and the shared error model.
• DBS function - write a value back to a cube.
• DBRA function - retrieve an element attribute.
• VIEW function - bind a block of DBRW formulas to a named view.