GetLinkedMember
EAZYBI Identifies and returns a member in the same dimension level or a specified hierarchy level that matches the key from the current member property.
Syntax
Member_Expression.GetLinkedMember(Property_Name) Member_Expression.GetLinkedMember(Property_Name, Level_Expression)
By default, the linked member is 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 a member within the dimension level. |
| Level_Expression | MDX expression specifying a member level for the linked member |
Examples
With the following expression, you can find the issue object of the current issue's Epic link
[Issue].CurrentHierarchyMember.GetLinkedMember('Epic Link')
To display the Epic Link created date for the Story issue, use the following formula
[Issue].CurrentHierarchyMember.
GetLinkedMember('Epic Link').
Get('Created at')
Note that both above functions will work only when Story and Epic are on the same level, e.g., Issue default hierarchy and Sub-task hierarchy. In the case of the Epic hierarchy, issues are not on the same level, and GetLinkedMember will not be able to find it. Change the linked members level to the default hierarchy "Issue" level to retrieve the results in other hierarchies:
[Issue].CurrentHierarchyMember.
GetLinkedMember('Epic Link', [Issue].[Issue]).
Get('Created at')
Report on additional issue links
To create measures on other issue links in Jira, you must first specify and import the issue link in your Import options or Advanced settings.
See also
This function is similar to the GetMemberByKey function. Note that with GetMemberByKey it is possible to find members in other hierarchies, levels or dimensions.