Returns TRUE if the first member is a child of the second member and, optionally, if the first member is equal to the second member.
Syntax
IsChild ( member1 , member2 [, INCLUDEMEMBER])
Parameter | Description |
---|---|
A member specification. | |
A member specification. | |
INCLUDEMEMBER | Optional. Use this keyword if you want IsChild to return TRUE if the first member is equal to the second member. |
Example
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 |
The following query is the same as the above query, except that it uses INCLUDEMEMBER. It returns all Market dimension members for which the expression IsChild([Market].CurrentMember, [East]) returns TRUE; in other words, the query returns East and all children of East.
SELECT Filter([Market].Members, IsChild([Market].CurrentMember, [East], INCLUDEMEMBER)) ON COLUMNS FROM Sample.Basic
East | New York | Massachusetts | Florida | Connecticut | New Hampshire |
---|---|---|---|---|---|
24161 | 8202 | 6712 | 5029 | 3093 | 1125 |