Difference between revisions of "XL3DoWriteback"

(Added link to XL3LookupRW)
Line 23: Line 23:
 
==See Also==
 
==See Also==
 
* [[Formula Reference]]
 
* [[Formula Reference]]
 +
* [[XL3LookupRW|XL3LookupRW formula reference]]
  
 
[[Category:Formulae]]
 
[[Category:Formulae]]
 
[[Category:Writeback]]
 
[[Category:Writeback]]

Revision as of 09:13, 18 January 2012

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

See Also