GetLinkedMember
EAZYBI Returns member with a specified key value in the same dimension level or specific hierarchy level.
Syntax
Member_Expression.GetLinkedMember(key_value) Member_Expression.GetLinkedMember(key_value, Level_expression)
By default, the linked member will be retrieved in the current member level. You can specify the desired level by adding a level expression.
Arguments
Member_Expression | MDX expression that returns a member. |
|---|---|
key_value | String or numeric expression that returns a key value that should be used to lookup a member of 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 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')
See also
This function is similar to GetMemberByKey function. Note that with GetMemberByKey it is possible to find members in other hierarchies, levels or dimensions.