ISLEAF
Description:
This function is used to return whether a specified member is a leaf member.
Syntax:
IsLeaf(Member_Expression)
Return Type:
LOGICAL
Parameters:
Parameter | Description |
|---|---|
Member_Expression1 | It is a valid MDX expression that returns a member. |
Example:
WITH MEMBER MEASURES.ISLEAFDEMO AS
IsLeaf([Date].[Fiscal].CURRENTMEMBER)
SELECT {MEASURES.ISLEAFDEMO} ON 0,
[Date].[Fiscal].MEMBERS ON 1
FROM [AdventureWorksMF]