Analysis Services
Properties
Returns a string containing a member property value.
Syntax
«Member».Properties(«String Expression»)
Remarks
The Properties function returns the value of the member property specified in «String Expression». The member property can be any of the standard member properties, such as NAME, ID, KEY, or CAPTION, or it can be a user-defined member property.
Example
In the Store dimension, if the Store Name level has an associated member property, Store Manager, the following example returns Smith:
[Store].[All Stores].[USA].[WA].[Bellingham].[Store 2].Properties("Store Manager")