All eazyBI for Jira eazyBI for Confluence Private eazyBI

GetLinkedMembers

EAZYBI Identifies and returns members in the same dimension level or a specified hierarchy level that match the keys from the current member property.

Syntax

Member_Expression.GetLinkedMembers(Property_Name [, Level_Expression])

By default, the linked members are retrieved at the current member level. You can specify the desired level by adding a level expression.

Arguments

Member_Expression

MDX expression that returns a member.

Property_Name  

Member property name that provides a key value that should be used to look up members within the dimension level.
Level_ExpressionMDX expression specifying a member level for the linked members

Examples

List of assigned users to the linked issues

With the following formula, you can find the linked issues of an issue and generate a list of user names assigned to them.

Generate(
  [Issue].CurrentHierarchyMember.GetLinkedMembers('Links of Issue'),
  [Issue].CurrentMember.GetString('Assignee name'),
  ', '
)

Number of bugs linked to the issue

Use the following formula to count the number of bugs linked to the issue currently in context.

Count(
  [Issue].CurrentHierarchyMember.GetLinkedMembers('Bugs')
)

List of issue fix versions and their release date

Use the following formula to get all issue fix versions' release dates from the issue currently in context. The result is returned as a comma-separated text list, e.g.,  '2025-12-22, 2026-02-22'

Generate(
  [Issue.Epic].CurrentHierarchyMember.GetLinkedMembers(
    'Fix version IDs',
    [Fix Version].[Version]
  ),
  Format(
    [Fix Version].CurrentHierarchyMember.Get('Release date'),
    'yyyy-mm-dd'
  ),
  ', '
)

Or use the following formula to get all issue fix version and their release dates from the issue currently in context. The result is returned as a comma-separated text list, e.g., 
'Version: 1.0 Release date: 22-Dec-2025
Version: 2.0 Release date: 22-Feb-2026'

Generate(
  [Issue.Epic].CurrentHierarchyMember.GetLinkedMembers(
    'Fix version IDs',
    [Fix Version].[Version]
  ),
  "Version: " ||
  [Fix Version].CurrentHierarchyMember.Name
  || " Release date: " ||
  Format(
    [Fix Version].CurrentHierarchyMember.Get('Release date'),
    'dd-mmm-yyyy'
  ),
  Chr(10)
)


See also

  • Function GetMembersByKeys is similar to this function; however, with GetMembersByKeys, it is possible to find members in other hierarchies, levels, or dimensions.
  • Function GetLinkedMember can be used to retrieve a single linked member.