Difference between revisions of "XL3DoWriteback2"
| Line 26: | Line 26: | ||
Please refer to [[XL3DoWriteback]] for further details. | Please refer to [[XL3DoWriteback]] for further details. | ||
| + | |||
| + | |||
| + | ==See Also== | ||
| + | * [[Formula Reference]] | ||
| + | * [[XL3LookupRW|XL3LookupRW formula reference]] | ||
| + | * [[XL3DoWriteback|XL3DoWriteback]] | ||
Revision as of 16:50, 30 October 2024
XL3DoWriteback2 should be used instead of XL3DoWriteback to write data back to Anaplan. It works the same way as XL3DoWriteback but it requires the current Anaplan value as additional argument.
Syntax
XL3DoWriteback2( PerformWriteback, IntitialValue, WriteValue, Connection, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )
Parameters
| Parameter | Description |
|---|---|
| PerformWriteback | A reference to a range containing a boolean value (TRUE or FALSE) specifying whether to actually perform the writeback. That cell's value will be reset to FALSE following the writeback operation |
| IntitialValue | The current value stored in Anaplan for that cell. Typically this is read from an AnaplanXL grid. |
| WriteValue | The value to be written. Typically an Excel cell reference. |
| Connection | Connection number to use |
| Hierarchy1,…, HierarchyN | Name of the hierarchy that the following member applies to e.g. "Measures" or "[Customer].[Customer Geography]" |
| Member1,…, MemberN | Either a single member unique name or an XL3Member formula |
Please refer to XL3DoWriteback for further details.
