CELLPROPERTYGET

This function is similar to CELLGET but with an additional parameter to return different optional properties of the referenced database cell. Which properties are supported depends on the database type.

Like CELLGET, CELLPROPERTYGET is for ODBO and XMLA-compliant databases only.

Syntax

=CELLPROPERTYGET( "cell_property_name", "data_connection", "cube","slice_element" {,"slice_element})

Example

=CELLPROPERTYGET("writable","BestPracticesOLAP","status","[status].[start]")