Is
The MDX Is function for Essbase returns TRUE if two members are identical.
Syntax
IS ( member1 , member2 )
member1 IS member2
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 |