Difference between revisions of "XL3DoWriteback2"
Line 1: | Line 1: | ||
− | XL3DoWriteback2 | + | XL3DoWriteback2 should be used instead of [[XL3DoWriteback]] to write data back to Anaplan. It works the same as [[XL3DoWriteback]] but takes one the additional "InitialValue" argument. |
Revision as of 16:39, 30 October 2024
XL3DoWriteback2 should be used instead of XL3DoWriteback to write data back to Anaplan. It works the same as XL3DoWriteback but takes one the additional "InitialValue" 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 |