WriteValue
Writes value to cells defined by the specified tuple and returns the tuple. The function can be used the same way to delete values from cells.
You can aggregate data using the year to date functionality. See the "Writing YTD data" topic.
Syntax
«Tuple» WriteValue(«Tuple», «Numeric Expression» | «String Expression»)
TargetCell WriteValue(TargetCell, Value)
This table describes the parameters:
| Parameters | Description |
|---|---|
TargetCell:
«Tuple»
|
Target cell's coordinate, the dimensionality of this tuple must be equal to the number of dimensions in cube. |
Value: «Numeric Expression»|«String
Expression»|«Null»
|
If Value is null, the cell's value is deleted. |
| Return value: | «Tuple», this function returns TargetCell
|
Example
SELECT FROM [TOTSALES] WHEREWriteValue(([2002], [Budget], [Austria], [ProView VGA 12], [January], [Units]), 42)