CELLWRITE

This function writes a value to a cell. It is valid for ODBO-compliant databases only. If you do not specify an element for each dimension, the default element is used for the elements that you do not specify.

Syntax

=CELLWRITE(value,"data_connection","cube","slice_element {,"slice_element"})

Example

=CELLWRITE(1000000,"BestPracticesOLAP","Analysis","[region].[all regions].[africa].[algeria]")