XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "XL3DoWriteback"

(Created page with 'Optionally writes a value to a specific cube cross-section. ==Syntax== {{Code|XL3DoWriteback( PerformWriteback, WriteValue, Connection, [Hierarchy1], [Member1],…, [Hierarchy1…')
 
(More detail for WriteValue)
Line 14: Line 14:
 
|-
 
|-
 
| {{Code|WriteValue}}
 
| {{Code|WriteValue}}
| The value to be written.
+
| The value to be written. Typically an Excel cell reference.
 
|-
 
|-
 
| {{Code|Connection}}
 
| {{Code|Connection}}

Revision as of 15:16, 25 March 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.
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

See Also