Export (0) Print
Expand All
Expand Minimize

IsLeaf (MDX)

Returns whether a specified member is a leaf member.


IsLeaf(Member_Expression) 

Member_Expression

A valid Multidimensional Expressions (MDX) expression that returns a 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]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft