Returns TRUE if the first member is a child of the second member.
IsChild ( member1 , member2 )
| member1 | A member specification. |
| member2 | A member specification. |
The following query returns all Market dimension members for which the expression
IsChild([Market].CurrentMember, [East]) returns TRUE; in other words,
the query returns all children of East.
SELECT Filter([Market].Members, IsChild([Market].CurrentMember, [East])) ON COLUMNS FROM Sample.Basic
| New York | Massachusetts | Florida | Connecticut | New Hampshire |
|---|---|---|---|---|
| 8202 | 6712 | 5029 | 3093 | 1125 |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |