Document toolboxDocument toolbox

GetMemberByKey

Owned by Elvis Kvalbergs
Last updated: Aug 31, 2022 by Gvido

Returns level member with a specified key value

Syntax

Dimension_Level_Expression.GetMemberByKey(key_value)

Arguments

key_value

String or numeric expression that returns a key value that should be used to lookup a member of the dimension level.

Examples

In the JIRA cube it can be used to  returns a parent issue member for a sub-task issue.

[Issue].[Issue].GetMemberByKey([Issue].CurrentHierarchyMember.get('Parent issue key'))