CELLPROPERTYGET

Similar to CELLGET but with an additional parameter which enables you to return these properties of the referenced database cell:
Property OLAP datasources CPM Relational datasources
Writable Y Y
Value Y Y
Note Y Y
Note_Author N Y
Note_Timestamp N Y
Like CELLGET, CELLPROPERTYGET is for ODBO and XMLA-compliant databases only.

Syntax

=CELLPROPERTYGET( "Cell property name", "Database Alias", "Cube", "Elements...")

Example

=CELLPROPERTYGET("writable","Best Practices OLAP","status","[status].[start]")
	 
Related topics