| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3DoWriteback"
| Line 11: | Line 11: | ||
|- | |- | ||
| {{Code|PerformWriteback}} | | {{Code|PerformWriteback}} | ||
| − | | A boolean value ({{TRUE}} or {{FALSE}}) specifying whether to actually perform the writeback. If this is an Excel Range then that | + | | A boolean value ({{TRUE}} or {{FALSE}}) specifying whether to actually perform the writeback. If this is an Excel Range then that cell's value will be reset to FALSE following the writeback operation |
|- | |- | ||
| {{Code|WriteValue}} | | {{Code|WriteValue}} | ||
Revision as of 10:16, 21 April 2011
Optionally writes a value to a specific cube cross-section.
Syntax
XL3DoWriteback( PerformWriteback, WriteValue, Connection, [Hierarchy1], [Member1],…, [Hierarchy13], [Member13] )
Parameters
| Parameter | Description |
|---|---|
| PerformWriteback | A boolean value (TRUE or FALSE) specifying whether to actually perform the writeback. If this is an Excel Range then that cell's value will be reset to FALSE following the writeback operation |
| 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 |
