Skip to main content
PRERELEASE CONTENT

FIRSTCHILD (MDX)

Returns the first child of the given member.

Returned Type

This function returns a member.

Syntax and Details

member_expression.FIRSTCHILD 

Where:

The function returns the first child of this member. To determine which child is first, the function considers the default order of the set of children.

Example

For example, consider the following hierarchy:

generated description: hierarchy example

Now consider the following query:

SELECT MEASURES.[%COUNT] ON 0, homed.zip.[34577].FIRSTCHILD ON 1 FROM patients 

                             Patient Count
Cypress                              1,089

For another example:

SELECT MEASURES.[%COUNT] ON 0, birthd.1960.FIRSTCHILD ON 1 FROM patients
                             Patient Count
Jan-1960                                  5

See Also

Purpose of this instance: Draft documentation
DocReleaseID: SupplyChain2025.1
Content loaded from:
/staging/learning/iris-doc/2025.1.x/doc/supply-chain/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/cache/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/ensemble/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/iris/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/security/en-us/src/
Excluded items: PAGE_bi, PAGE_deployment, PAGE_interoperability, PAGE_release
FeedbackOpens in a new tab