DBS function#

DBS, DBSW, and DBSS send (write) a value back to a cube cell. DBS and DBSW write numeric values; DBSS writes a string. They are the building block of write-back grids that push values into Planning Analytics.

DBS, DBSW, and DBSS are native TM1 / Planning Analytics functions; Reportworq evaluates them against the workbook's TM1 connection.

Signature#

The value to send is the first argument, followed by the same Server:Cube and element arguments as DBRW.

=DBS(value, "Server:Cube", element1, ... elementN)
=DBSS(stringValue, "Server:Cube", element1, ... elementN)

Arguments#

#	Argument	Type	Required	Permitted values and notes
1	`value`	Number or string	Yes	The value to send. An Excel error value is treated as no value.
2	`Server:Cube`	String	Yes	`"server:cube"`.
3..N	element per dimension	String	Yes	One element per cube dimension, in cube-dimension order.

What happens when an argument is wrong#

For the shared error model and the Calc Mode effect, see how Reportworq handles errors.

Situation	Result
`DBS` or `DBSW` targets a consolidated numeric cell without proportional write-back enabled	Hard error - consolidated input is not supported
`DBSS` targets a numeric cell	Hard error - `DBSS` does not update numeric values
`DBS` targets a string cell	Hard error - `DBS` does not update string values
An invalid element	Calc Mode on: hard error. Calc Mode off: warning, the cell stops
The referenced server is not connected	Hard error

Notes and limits#

These are write-back functions: they only send a value when the workbook runs in write-back (a contribution submission or a write-back job) and otherwise return blank.
With proportional write-back enabled on the connection, a value sent to a consolidated numeric cell is spread proportionally instead of erroring.

Examples#

=DBS(B5, "PlanTM1:Sales", "Northeast", "Widget", "Jan", "Revenue")
=DBSS("Approved", "PlanTM1:Sales", "Northeast", "Widget", "Jan", "Status")

IBM Planning Analytics functions - the function index and the shared error model.
DBRW function - retrieve a cube cell value.

Feedback on this page

Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.

Email feedback on this page

Or write to support@reportworq.com directly.