Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
| 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.