MDX Function and Operator Reference - Professional SQL Server Analysis Services 2005 with MDX - page 1111

member .Properties ( property name , TYPED) Returns: various Extension:
AS2005
Returns the value of the named property at the member. The property name
can be a string expression. If it is, the name expression is evaluated cell by
cell every time the property reference is.
Even though Analysis Services 2000 and 2005 support member properties in
a variety of data types, the return value of the .Properties () function is co-
erced to be a string unless you include the TYPED flag. Then, the property
value is returned in its internal data type.
In Analysis Services, every member has associated properties named
CAPTION, NAME, ID, and KEY.
See also: .PropertyName, .MemberValue, StrToMember (), StrToSet (),
StrToTuple (), StrToValue (), Members (), Dimensions (), Levels ()
member . PropertyName Returns: string, number, boolean Standard (except
AS2000, AS2005)
In Essbase, a property value associated with a member is referenced by
member.PropertyName , where the name of the property is literally placed in
the MDX. For example, the following retrieves the ClubStatus property value
for the current Customer member:
[Customer].CurrentMember.[ClubStatus]
Since the syntax for this kind of property reference is similar to the syntax for
a number of functions, you should always use delimited names (in []) for prop-
erty names.
See also: .Properties (), .MemberValue, StrToMember (), StrToSet (),
StrToTuple (), StrToValue (), Members (), Dimensions (), Levels ()
Q
QTD ([ member ]) Returns: set Standard
QTD () is the equivalent of PeriodsToDate () with the level set to Quarter. If
member is not specified, it defaults to the current member of the Time-typed