DBSET2

DBSET2 functions in the same way as DBSET but takes an additional argument.

Syntax

DBSET2(Value,Mode,Database alias,Cube,Element1...Elementn)

With the Mode argument you specify whether the value sent should overwrite the contents of the cell or be added to it.

Note: A function that adds values and does not replace them can be dangerous. If you use incremental writing and do not use manual recalculation in the worksheet, DBSET2 will change the value of the target cell every time you modify your sheet. This is a dangerous situation because the cube is changed. So, there are different modes of incrementing values.

This table describes the Mode argument:


Mode	Description
Mode 0	The value in the cube cell is overwritten.
Mode 2	If you use Mode 2, the value in the cube cell is incremented. This adds the values to the cube only while processing a file or cube (Processing data from cubes). When editing the worksheet the database cells do not change. The function returns #value.
Mode 3	If you use Mode 3, the value in the cube cell is incremented. In this mode the function is evaluated at each calculation. DBSET2 is especially useful with data transfer within networks and can be three times faster than DBSET. Caution: Use mode 3 with extreme caution.