Skip to content

Latest commit

 

History

History
40 lines (29 loc) · 924 Bytes

File metadata and controls

40 lines (29 loc) · 924 Bytes
title FirstChild (MDX) | Microsoft Docs
ms.date 06/04/2018
ms.prod sql
ms.technology analysis-services
ms.custom mdx
ms.topic reference
ms.author owend
ms.reviewer owend
author minewiskan

FirstChild (MDX)

Returns the first child of a specified member.

Syntax

  
Member_Expression.FirstChild   

Arguments

Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.

Example

The following query returns the first child of fiscal year 2003 in the Fiscal hierarchy, which is the first semester of Fiscal Year 2003.

SELECT [Date].[Fiscal].[Fiscal Year].&[2003].FirstChild ON 0  
FROM [Adventure Works]  

See Also

LastChild (MDX)
MDX Function Reference (MDX)