Edit

Share via

IsLeaf (MDX)

  • Article

Returns whether a specified member is a leaf member.

Syntax

  
IsLeaf(Member_Expression)

Arguments

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

Remarks

The IsLeaf function returns true if the specified member is a leaf member. Otherwise, the function returns false.

Example

The following example returns TRUE if [Date].[Fiscal].CurrentMember is a leaf member:

WITH MEMBER MEASURES.ISLEAFDEMO AS  
IsLeaf([Date].[Fiscal].CURRENTMEMBER)  
SELECT {MEASURES.ISLEAFDEMO} ON 0,  
[Date].[Fiscal].MEMBERS ON 1  
FROM [Adventure Works]

See Also

MDX Function Reference (MDX)