FIRSTCHILD

FIRSTCHILD

Description:

This function is used to return the first child of a specified member.

Syntax:

Member_Expression.FirstChild

Return Type:

MEMBER

Parameters:

Parameter

Description

Parameter

Description

Member_Expression

It is a valid MDX expression that returns a member.

Example:

SELECT [Measures].[Internet Sales Amount] ON COLUMNS, [Product].[Product Categories].[Category].&[Bikes].FirstChild ON ROWS FROM [AdventureWorksMF_ValueBased]

 

Copyright Kyvos, Inc. 2026. All rights reserved.