DBSW

DBSW sends a numeric value to a cube. This function cannot send a string to a cube. To send strings, use the DBSS function.

This function works the same as the DBS function, with one major difference; DBSW reduces network traffic and may improve performance on wide area networks.

In worksheets with a large number of cube references, DBSW forces Planning Analytics to send values in bundles rather than individually. Normal DBS functions are updated individually during a recalculation. DBSW references force Planning Analytics to send all changed values within a worksheet in a single bundle.

In such circumstances you can safely use a DBS/DBR function as an argument to a DBS function.

Note: If you use VBA to calculate a worksheet containing DBSW functions, you must call the TM1® macro functionto calculate the worksheet. Do not use the VB Calculate method to calculate a worksheet containing DBSW functions; doing so causes each DBSW function to be executed individually, defeating the purpose of the function and resulting in decreased performance.

This worksheet function is valid in worksheets only.

Syntax

DBSW(value, cube, e1, e2[,...en])

Argument

Description

value

The value being sent.

cube

The cube to which the value is sent.

e1, ...en

The names of elements defining the intersection in the cube to which the value is sent.

Arguments e1 through en are sequence sensitive. e1 must be an element from the first dimension of the cube, e2 must be an element from the second dimension of the cube, and so on. These arguments can also be the names of aliases for dimension elements.

Numeric element names must be enclosed in quotation marks.

Example

DBSW(5342,"92act4d","California","3.5 Diskettes", "NetSales", "January")