.png)
IsLeaf (MDX)
SQL Server 2012
Returns whether a specified member is a leaf member.
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]
