| description | IsSibling (MDX) |
|---|---|
| title | IsSibling (MDX) | Microsoft Docs |
| ms.date | 02/17/2022 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | mdx |
| ms.topic | reference |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
Returns whether a specified member is a sibling of another specified member.
IsSibling(Member_Expression1, Member_Expression2)
Member_Expression1
A valid Multidimensional Expressions (MDX) expression that returns a member.
Member_Expression2
A valid Multidimensional Expressions (MDX) expression that returns a member.
The IsSibling function returns true if the first specified member is a sibling of the second specified member. Otherwise, the function returns false.
The following example returns TRUE if the current member on the Fiscal hierarchy of the Date dimension is a sibling of July 2002:
WITH MEMBER MEASURES.ISSIBLINGDEMO AS
IsSibling([Date].[Fiscal].CURRENTMEMBER, [Date].[Fiscal].[Month].&[2002]&[7])
SELECT {MEASURES.ISSIBLINGDEMO} ON 0,
[Date].[Fiscal].MEMBERS ON 1
FROM [Adventure Works]