ISSIBLING

This formula returns 1 if two specified elements are siblings in the hierarchy, 0 if they are not.

Syntax

=MDX.GET(Database Alias, Cube, "IsSibling("&"Element unique name"&","&"Element unique name"&")")

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

Example

This formula returns 1 because, in the Best Practices sample database, All Season Tires and Summer Tires are siblings:

=MDX.GET("Best Practices OLAP", "ANALYSIS", "IsSibling("&"[PRODUCT].[All Tires].[Car Tires All Season]"&","&"[PRODUCT].[All Tires].[Car Tires Summer]"&")")