All eazyBI for Jira eazyBI for Confluence Private eazyBI

CurrentMember

When iterating through the hierarchy or set of members, the CurrentMember function dynamically returns the member being operated upon.
It is like saying, "You are here," and the value is calculated for this particular member.

Syntax

Dimension_Expression.CurrentMember

or

Hierarchy_Expression.CurrentMember

Arguments

Dimension_Expression

Hierarchy_Expression

MDX expression to return a dimension at the default hierarchy

or specified hierarchy for the dimension

Examples

Example with default Issue hierarchy

[Issue].CurrentMember address Issue dimension current member from the default hierarchy. In this example, List of issues in progress, the dimension Issue default hierarchy on the level Issue is used on Rows. [Issue].CurrentMember addresses one particular issue for each row.

Example with Issue.Epic hierarchy

Another example report Issue Epic Gantt chart, where the dimension Issue.Epic hierarchy on the Epic level is used on Rows. [Issue.Epic].CurrentMemberaddresses one particular epic for each row in the same report. See also CurrentHierarchyMember to address members of any selected hierarchy.

Example with Descendants

Calculated measures can iterate through dimension members even if the dimension is not selected in report rows, columns, or pages. The function CurrentMember addresses each member from a particular dimension and it tells where the calculation is being executed.

It can be used with set functions where the most popular ones are Childrenset, Descendants, and Members.

The following example would return the issue count of issues created and resolved in the same period (complex filtering criteria).

NonZero(
Sum(
  Filter(
    -- iterate through set of issues
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    -- apply filter criteria to each issue
    DateInPeriod( 
      [Measures].[Issue created date],
      [Time].CurrentHierarchyMember
    )
    AND
    DateInPeriod( 
      [Measures].[Issue resolution date],
      [Time].CurrentHierarchyMember
    )
  ),
  -- numeric expression - sum of relevant issues
  [Measures].[Issues created] 
))

See also