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')
)
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.