All eazyBI for Jira eazyBI for Confluence Private eazyBI

IS and NOT IS

IS and NOT IS are Mondrian-specific functions that compare a dimension member to another.

Syntax

Member_Expression IS Member_Expression

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

Returns true if a particular user from the Assignee dimension is user Raimonds Simanovskis

[Assignee].CurrenthierarchyMember IS [Assignee].[Raimonds Simanovskis]


Returns true if the project in the report context is NOT Demo Alpha. Note that NOT must be used at the beginning.

NOT [Project].CurrenthierarchyMember IS [Project].[Demo Alpha]

See also

  • Function Matches() to compare member names with string values or regular expressions