WriteValue
Writes a value to a cell defined by the specified tuple and returns the tuple. This function can be used in the same way to delete a cell value.
You can aggregate data using the year-to-date functionality. See the "Writing YTD data" topic.
Syntax
«Tuple1» WriteValue(«Tuple2», «Numeric Expression» | «String Expression» | Null)This table describes the parameters:
| Parameters | Description |
|---|---|
«Tuple1» |
This function returns the target cell as a tuple. |
«Tuple2» |
The target cell's coordinate as a tuple. The dimensionality of this tuple must be equal to the number of dimensions in the cube. |
«Numeric Expression» | «String Expression» | Null |
If Null, the cell's value is deleted. |
Example 1
SELECT FROM [DCS_Planning]
WHERE WriteValue(([Units], [01_2017], [AS600/175]), 42)Example 2
SELECT FROM [DCS_Planning]
WHERE WriteValue(([Units], [01_2017], [AS600/175]), Null)
With this function you cannot execute a splashing operation. Use SplashValue instead.