IsLeaf (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)