ISSIBLING
Description:
This function is used to return a true value if both members are siblings (i.e., have the same parent).
Syntax:
IsSibling(Member_Expression1, Member_Expression2)
Return Type:
LOGICAL
Parameters:
Parameter | Description |
|---|---|
Member_Expression1 | It is a valid MDX expression that returns a member. |
Member_Expression2 | It is a valid MDX expression that returns a member. |
Example:
with member
[MEASURES].ISSIBLINGDEMO as
IsSibling([Customer].[Geography].[Country].&[Australia],
[Customer].[Geography].currentmember)
SELECT {[MEASURES].ISSIBLINGDEMO} ON 0,
[Date].[Fiscal].MEMBERS ON 1
FROM [AdventureWorksMF]