CELLPROPERTYGET
Similar to CELLGET but with an additional parameter which enables you
to return these properties of the referenced database cell:
Like CELLGET, CELLPROPERTYGET is for ODBO and XMLA-compliant
databases only.
| Property | OLAP datasources | CPM Relational datasources |
|---|---|---|
| Writable | Y | Y |
| Value | Y | Y |
| Note | Y | Y |
| Note_Author | N | Y |
| Note_Timestamp | N | Y |
Syntax
=CELLPROPERTYGET( "Cell property name", "Database Alias",
"Cube", "Elements...")
Example
=CELLPROPERTYGET("writable","Best Practices OLAP","status","[status].[start]")
Related topics