Is

The MDX Is function for Essbase returns TRUE if two members are identical.

Syntax

IS ( member1 , member2 )

member1 IS member2

Parameters

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:

Table 4-86 Output Grid from MDX Example

New York	Massachusetts	Florida	Connecticut	New Hampshire
8202	6712	5029	3093	1125