IsChild

The MDX IsChild function for Essbase 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])

Parameters

member1: A member specification.
member2: 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 1

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

The above query returns the following output:

Table 4-90 Output Grid from MDX Example

New York	Massachusetts	Florida	Connecticut	New Hampshire
8202	6712	5029	3093	1125

Example 2

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

The above query returns the following output:

Table 4-91 Output Grid from MDX Example

East	New York	Massachusetts	Florida	Connecticut	New Hampshire
24161	8202	6712	5029	3093	1125