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