Skip to main content

Properties

Returns the value of the specified member for the specified member property. Can be used for both system- and user-defined member properties.

Note

For information on working with user-defined member properties in AtScale, see Using MDX User-Defined Member Properties.

Syntax​

Member_Expression.Properties(Property_Name [, TYPED])

Input Parameters​

Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.

Property_Name
A valid string expression of a member property name.

TYPED
A constant indicating that the return value should be strongly typed and not coerced to a string.

Return Value​

The Properties function returns the value of the specified member for the specified member property. By default, the value is coerced to be a string. If TYPED is specified, the return value is strongly typed.

Example​

Return TRUE if the [Product Categories] member's LEVEL_NUMBER is "1", else return FALSE. (Note the quotes indicating that the return value is a String.)

[Product].[Product Categories].CurrentMember.Properties("LEVEL_NUMBER") = "1"

Return TRUE if the [Product Categories] member's LEVEL_NUMBER is 1, else return FALSE (Note the use of the TYPED parameter to perform the comparison in using the property's native type, Integer in this case).

[Product].[Product Categories].CurrentMember.Properties("LEVEL_NUMBER", TYPED) = 1