Returns TRUE if the first member is an ancestor of the second member.
IsAncestor ( member1 , member2 )
member1 | A member specification. |
member2 | A member specification. |
The following query returns all Market dimension members for which the expression
IsAncestor([Market].CurrentMember, [Florida])
returns TRUE; in other words,
the query returns all ancestors of Florida.
SELECT Filter([Market].Members, IsAncestor([Market].CurrentMember, [Florida])) ON COLUMNS FROM Sample.Basic
Market | East |
---|---|
105522 | 24161 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |