Returns TRUE if two members are identical.
IS ( member1 , member2 )
OR
member1 IS member2
member1 | First member specification. |
member2 | Second member specification. |
IS([Year].CurrentMember.Parent, [Qtr1])
returns TRUE if the parent of the current member in[Year]
dimension is[Qtr1]
.
Filter([Year].Levels(0).members, IS([Year].CurrentMember.Parent, [Qtr1]))
returns children of [Qtr1]
.
The following query returns all members of [Market] that have the parent [East]; in other words, children of [East].
SELECT { Filter ( [Market].members, [Market].CurrentMember.Parent IS [East] ) } on columns FROM sample.basic
This query returns the following grid:
New York | Massachusetts | Florida | Connecticut | New Hampshire |
---|---|---|---|---|
8202 | 6712 | 5029 | 3093 | 1125 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |