Export (0) Print
Expand All

Properties

SQL Server 2000

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")
Show:
© 2014 Microsoft