Is

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

Syntax

IS ( member1 , member2 )

or

member1 IS member1

Parameters

member1

First member specification.

member2

Second member specification.

Example

The following expression:

IS([Year].CurrentMember.Parent, [Qtr1]) 

returns TRUE if the parent of the current member in [Year] dimension is [Qtr1].

The following expression:

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

The above 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