All eazyBI for Jira eazyBI for Confluence Private eazyBI

Key

Returns the key of the selected member.

Syntax

Member_Expression.Key

Arguments

Member_Expression

MDX expression that returns a member.

Examples

Get Issue key

The following formula returns the Key of the current issue. If individual Issues are selected in Rows, then a measure with this formula will display the key for each of them.

[Issue].CurrentHierarchyMember.Key

Hours spent by Assignee on assigned issues

If you create a report with Assignee members in Rows, you can use the Hours spent measure to show the hours logged toward the issues assigned to the users. This, however, will also show the hours logged by other users as well. The following formula will allow you to show hours logged by the user that has been assigned to the issue:

(
  [Measures].[Hours spent],
  [Logged by].[User].GetMemberByKey(
    [Assignee].CurrentHierarchyMember.Key
  )
)

This formula uses the Key function to get the Key of the Assignee user in Rows and then uses this Key to match with the same user in the Logged by dimension. This will allow you to show only the hours logged by this same user.

See also