Skip to main content

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