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.

SeeCELLPROPERTYGET

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]")