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 |