Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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")