Returns true if the two members are siblings (i.e., have the same parent).
In our example, returns true as [Geneva] and [Zurich] are siblings (i.e., same parent [Switzerland]).
Query
WITH
MEMBER [Measures].[isSibling] AS IsSibling( [Geography].[Geneva], [Geography].[Zurich] )
SELECT
[Measures].[isSibling] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[isSibling] AS TRUE
SELECT
[Measures].[isSibling] ON 0
FROM
[Sales]
Returns false if the two members are not siblings (they have different parent).
In our example, returns false as [Geneva] and [Paris] are not siblings: different parents ([Switzerland] and [France]).
Query
WITH
MEMBER [Measures].[isSibling] AS IsSibling( [Geography].[Geneva], [Geography].[Paris] )
SELECT
[Measures].[isSibling] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[isSibling] AS FALSE
SELECT
[Measures].[isSibling] ON 0
FROM
[Sales]
Returns true if both members are root members (they have no parent).
In our example, returns true as [2010] is a sibling of [2011]: both root members.
Query
WITH
MEMBER [Measures].[isSibling] AS IsSibling( [Time].[Calendar].[2010], [Time].[Calendar].[2011] )
SELECT
[Measures].[isSibling] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[isSibling] AS TRUE
SELECT
[Measures].[isSibling] ON 0
FROM
[Sales]