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