MDX Siblings Function

In Multidimensional Expression, Siblings function will return all the Child members that belongs to the parent of a specified member OR We can simply say, Siblings function will return all the Siblings of a specified member. For example, If you know single customer name and if you want to find the Sales of all the customers present in that group then you can use this Siblings function.

MDX Siblings Function Syntax

The basic syntax of the MDX Siblings is:

1	Member_Expression.SIBLINGS

Member_Expression: Any Multidimensional Expression that returns valid Member.

In this article we will show you, How to write Siblings function  in MDX query with examples. For this, We are going to use the below show data

Following screenshot shows the Countries inside the Geography

 

Following screenshot shows the [State – Provinces] inside the France Country

MDX Siblings Function Example

In this example we are going to use Siblings function to find the siblings of a France Country.

CODE

1 2 3 4

SELECT   [Measures].[Reseller Sales Amount] ON COLUMNS,   [Geography].[Geography].[Country].[France].SIBLINGS ON ROWS FROM [Adventure Works];

OUTPUT

Analysis:

In the above MDX Query, We used [Reseller Sales amount] on the columns

1	[Measures].[Reseller Sales Amount] ON COLUMNS

Below line of code will check for the France parent (Which is All member) and then displays all the child member of the Country.

1	[Geography].[Geography].[Country].[France].SIBLINGS

MDX Siblings Function Example 2

If we know the Loiret is one of the state in France and our intention is to find the remaining states present in France then, we can use this Siblings function. In this example we are going to find all the Child Members present in the State Province list and calculate the Reseller Sales Amount of that.

CODE

1 2 3 4

SELECT [Measures].[Reseller Sales Amount] ON COLUMNS, [Geography].[Geography].[State-Province].[Loiret].SIBLINGS ON ROWS FROM [Adventure Works];

OUTPUT

MDX Siblings Function Alternative

In this example we are going to use the Siblings function alternative to achieve the same result. Please refer MDX Parent Function to understand the Parent function and refer MDX Children function to understand the Children function.

CODE

1 2 3 4

SELECT [Measures].[Reseller Sales Amount] ON COLUMNS, [Geography].[Geography].[State-Province].[Loiret].PARENT.CHILDREN ON ROWS FROM [Adventure Works];

OUTPUT

Analysis:

In the above MDX Query, We used [Reseller Sales amount] on the columns

1	[Measures].[Reseller Sales Amount] ON COLUMNS

From Below line of code,

1	[Geography].[Geography].[State-Province].[Loiret].PARENT.CHILDREN

MDX will first implement the Parent function to find the parent member of a [Loiret], Which is France.

Next, It will implement Children function to find all the Child member belongs to the France Country.

Thank you for Visiting Our Blog