GetMemberByKey

EAZYBI 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

[Issue].[Issue].GetMemberByKey([Issue].CurrentHierarchyMember.get('Parent issue key')) returns a parent issue member for a sub-task issue.


If this function is used in a tuple code, sequence of members is very important - getmemberbykey function that references to a dimension should be before the dimension itself.

(
[Measures].[Issues created],
[JIRA Project Name].[JIRA Project Name].getMemberbykey(
	[Project].CurrentMember.Name
	),
[Project].DefaultMember
)



See also

There is a similar function GetLinkedMember.