CELLPROPERTYWRITE
Writes a value to a specified property of a cell.
If you do not specify an element for each dimension, the default element is used for the elements that you do not specify.
Note: Like CELLPROPERTYGET, CELLPROPERTYWRITE is for ODBO-compliant databases only.
The value is written as soon as the function is triggered.
Note: We recommend that
CELLPROPERTYWRITE is used only in the parameters of actions.
WBC is a non-dynamic equivalent of CELLPROPERTYWRITE.
Syntax
=CELLPROPERTYWRITE(value,"cell_property_name","data_connection","cube",
"slice_element" {,"slice_element"})Example
=CELLPROPERTYWRITE("Cell note","note","BestPracticesOLAP","Status","[Status].
[Start]","[version].[actual]")Example
=CELLWRITE("123321","BestPracticesOLAP","Status","[Version].[Actual]","[Status].[Start]")