xpna.DATAWRITE FUNCTION
Usage
The DATAWRITE function is used to write a new value to the database for a specified data point. To do this, just type the new number over the top of the existing one, and xpna will detect this and perform the update in the database.
Note:
Pasting of a range of numeric values over a range of xpna.DATAWRITE cells is supported and will cause all those writebacks to occur at once.
The function expects at least three MEMBER and does not allow the use of multiple members from the same hierarchy.
This is a context-aware function, so when selected, the xpna task pane will show a Drill to transactions action button.
Syntax
| Argument | Description |
|---|---|
| member 1 | A reference to a single MEMBER cell. |
| member 2 | A reference to a single MEMBER cell. |
| member 3 | A reference to a single MEMBER cell. |
| [member4..member15] | A reference to a single MEMBER cell. (optional) |
Common Problems
- The function will return an error if you do not provide at least three member ID or cell reference.
- The function will return an error if the hierarchies Scenario, Account and Period are not used
- The function will return an error if the data point cannot be written to (e.g., if it is for a read-only scenario).
- All members must resolve to a valid member for your workspace.