IsChild

Returns TRUE if the first member is a child of the second member.

Syntax

IsChild ( member1 , member2 )

member1 A member specification.
member2 A member specification.

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

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com