MDX Member Value Expressions

OLE DB Programmer's Reference

Member value expressions identify the elements of the members dimension. The construct is as follows:

<member_value_expression> ::= <member>.{PARENT | FIRSTCHILD | LASTCHILD                                         | PREVMEMBER | NEXTMEMBER}                             | <member>.LEAD(<index>)                             | <member>.LAG(<index>)

Note   LAG(<index>) is the same as LEAD(–<index>)

                            | <member>.{FIRSTSIBLING | LASTSIBLING}                             | <dimension>[.CURRENTMEMBER]                             | <dimension>.DEFAULTMEMBER                             | <hierarchy>.DEFAULTMEMBER                             | ANCESTOR(<member>, <level>)                             | CLOSINGPERIOD(<level>[, <member>])                             | COUSIN(<member>, <member>)                             | OPENINGPERIOD(<level>[, <member>])                             | PARALLELPERIOD([<level>[, <index>                                              [, <member>]]])

The following table identifies and describes the elements of a member value expression.

Element	Description
<member>.{PARENT}	Names the parent of a member.
<member>.{FIRSTCHILD}	Returns the first child of a member according to an implicit natural order. (The children of any member are arranged along this natural order.)
<member>.{LASTCHILD}	Names the last child of a member according to the natural order.
<member>.{PREVMEMBER}	Names the previous member along the level implied by <member>.
<member>.{NEXTMEMBER}	Names the next member along the level implied by <member>.
<member>.LEAD(<index>)	Gives the member that is <index> positions away along the member's dimension, in the dimension's natural order. The numbering of the positions is zero-based. The function <member>.LAG is similar, except that it looks in the opposite direction. If <index> is negative, LEAD becomes LAG, and vice versa.
<dimension>[.CURRENTMEMBER]	Gives the current member along <dimension>. The concept of "currency" occurs in functions such as GENERATE, where the semantics include some form of iteration through members of a set.
<member>.{FIRSTSIBLING | LASTSIBLING}	Returns the first/last sibling at the parent level of the <member>. For example, May.FIRSTSIBLING returns April, and the expression May.LASTSIBLING returns June (assuming that the parent level is Quarters).

Consumers can check the value of the property MDPROP_MDX_MEMBER_FUNCTIONS to see whether a provider supports these expressions.

1998-2001 Microsoft Corporation. All rights reserved.