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 |