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 look up a member of the dimension level. |
---|
Examples
Parent issue member for a sub-task issue
returns a parent issue member for a sub-task issue. It is used in default Issue properties: Issue sub-task keys and Issue open sub-task keys.
[Issue].[Issue].GetMemberByKey( [Issue].CurrentHierarchyMember.Get('Parent issue key') )
Hours spent on any issue
If this function is used in a tuple code, the sequence of members is crucial - the GetMemberByKey function that references to a dimension should be before the dimension itself. The formula below will switch the Assignee user with Logged by user in the formula. It will find the Logged by user based on the Assignee user; after the switch, the tuple will ignore the Assignee role for this user and retrieve logged hours based on the Logged by role for the user only.
( [Measures].[Hours spent], [Logged by].[User].GetMemberByKey( [Assignee].CurrentMember.Key ), [Assignee].DefaultMember )
See the example report Logged hours by user on assigned and unassigned issues in our demo account. The measure Hours spent on any issue use the formula above.
Hours spent on assigned issues
The following example will use both roles, Logged by and Assignee, for the user. The formula will pull in logged hours by the user only from currently assigned issues:
( [Measures].[Hours spent], [Logged by].[User].GetMemberByKey( [Assignee].CurrentMember.Key ) )
See the example report Logged hours by user on assigned and unassigned issues in our demo account. The measure Hours spent on assigned issues use the formula above.
See also
- There is a similar function GetLinkedMember
- Tuple expression