SIBLINGS
Description:
This function is used to return the siblings of a specified member, including the member itself.
Syntax:
Member_Expression.Siblings
Return type:
SET
Parameters:
Parameter | Description |
|---|---|
Member_Expression | It is a valid MDX expression that returns a member. |
Example:
WITH MEMBER [Measures].[Avg Sibling Sales] AS
AVG([Product].[Product Categories].CurrentMember.Siblings, [Measures].[Internet Sales Amount])
MEMBER [Measures].[Sibling Count] AS
Count([Product].[Product Categories].CurrentMember.Siblings)
SELECT {[Measures].[Internet Sales Amount], [Measures].[Avg Sibling Sales], [Measures].[Sibling Count]}
ON COLUMNS,
[Product].[Product Categories].[Category].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]