All eazyBI for Jira eazyBI for Confluence Private eazyBI

GetLinkedMember

EAZYBI Returns a 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 look up a member of the dimension level.
Level_ExpressionMDX 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')


(warning) 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.