Is

Returns TRUE if two members are identical.

Syntax

IS ( member1 , member2 )

OR

member1 IS member2

member1 First member specification.
member2 Second member specification.

Example

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