All eazyBI for Jira eazyBI for Confluence Private eazyBI

GetMemberNamesByKeys

EAZYBI Returns a comma-separated string of level member names by their keys. It works the same way as GetMemberNameByKey, but instead of a single key, it accepts a comma-separated list of keys and returns their names as a comma-separated string.

Syntax

Dimension_Level_Expression.GetMemberNamesByKeys(Keys_Value)

Arguments

Keys_Value

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

Examples

Issue Sprints

The GetMemberNamesByKeys function is used for the predefined "Issue Sprints" measure to return a list of sprint names that an issue is associated with:

[Sprint].[Sprint].GetMemberNamesByKeys(
  [Issue].CurrentHierarchyMember.Get('Sprint IDs')
)

Issue fix versions

The function is also used for the predefined "Issue fix versions" measure to return the names of versions that the issue is associated with:

[Fix Version].[Version].GetMemberNamesByKeys(
  [Issue].CurrentHierarchyMember.Get('Fix version IDs')
)

See also