Returns true if the member is a leaf (i.e., no child).
In our example, returns true as [Zurich] has no children.
Query
WITH
MEMBER [Measures].[IS_LEAF] AS isLeaf([Geography].[Geo].[Zurich])
SELECT
[Measures].[IS_LEAF] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[IS_LEAF] AS true
SELECT
[Measures].[IS_LEAF] ON 0
FROM
[Sales]
Assertion : MDX Equals
WITH
MEMBER [Measures].[IS_LEAF] AS IIF( [Geography].[Geo].[Zurich].children.count = 0, true, false )
SELECT
[Measures].[IS_LEAF] ON 0
FROM
[Sales]
Returns false for no leaf members.
In our example, return false for [Switzerland] as it is not a leaf member (i.e., has several cities as children).
Query
WITH
MEMBER [Measures].[IS_LEAF] AS isLeaf([Geography].[Geo].[Switzerland])
SELECT
[Measures].[IS_LEAF] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[IS_LEAF] AS false
SELECT
[Measures].[IS_LEAF] ON 0
FROM
[Sales]
Assertion : MDX Equals
WITH
MEMBER [Measures].[IS_LEAF] AS IIF( [Geography].[Geo].[Switzerland].children.count = 0, true, false )
SELECT
[Measures].[IS_LEAF] ON 0
FROM
[Sales]
Returns false if applied to a NULL entity.
Query
WITH
MEMBER [Measures].[IS_LEAF] AS isLeaf( null )
SELECT
[Measures].[IS_LEAF] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[IS_LEAF] AS FALSE
SELECT
[Measures].[IS_LEAF] ON 0
FROM
[Sales]