All eazyBI for Jira eazyBI for Confluence Private eazyBI

GetMembersByKeys

EAZYBI Returns a set of members from a dimension by their keys. It works the same way as GetMemberByKey, but instead of a single key, it accepts a comma-separated list of keys and returns all corresponding members as a set.

Syntax

Dimension_Level_Expression.GetMembersByKeys(Keys_Value)

Arguments

Keys_Value

String expression that returns comma-separated key values that should be used to look up members of the dimension level.

Examples

Return a set of linked bug issues

In the following formula, the imported linked issue property containing the keys of linked issues is used to retrieve a set of these linked issues that can then be used to do calculations across these linked issues.

[Issue].[Issue].GetMembersByKeys(
  [Issue].CurrentHierarchyMember.Get('Linked Bugs')
)

Issue first Sprint

The issue property "Issue Sprint" contains the current Sprint that the issue is associated with. To determine the first sprint that the issue was added to, you can use the Head function in combination with GetMembersByKeys:

CASE WHEN
  [Measures].[Issue Sprint] <> '(no sprint)'
THEN
  Head(
    [Sprint].[Sprint].GetMembersByKeys(
      [Issue].CurrentHierarchyMember.Get('Sprint IDs')
    ),
    1
  ).Item(0).Name
END


See also

  • To return a single member from a single key, use the GetMemberByKey function.
  • Function Head returns the specified number of members from the beginning of a set.