CELLPROPERTYWRITE
Writes a value to a specified property of a cell.
If you do not specify an element for each dimension of the cube, the default element is used for the elements which 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.
See WBC
Syntax
=CELLPROPERTYWRITE( "value", "cell property", "database alias", "cube", "slice element dimension 1", ..., "slice element dimension N")
Example
=CELLPROPERTYWRITE("Cell note","note","Best Practices OLAP","Status","[Status]. [Start]","[version].[Actual]")
Example
=CELLWRITE("123321","Best Practices OLAP","Status","[Version].[Actual]","[Status].[Start]")