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_Expression | MDX 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.