FirstChild

The MDX FirstChild function for Essbase returns the first child of the input member.

Syntax

member.FirstChild

FirstChild ( member )

Parameters

member: A member specification. If a level-0 member, the output of FirstChild is an empty member.

Example

SELECT
  {[Qtr1].firstchild} 
ON COLUMNS,
  {[Market].[Central].lastchild} 
ON ROWS
FROM Sample.Basic

The above query returns the following result:

Table 4-71 Output Grid from MDX Example

(axis)	Jan
Colorado	585