CurrentUser
EAZYBI Returns a key value of the user (from Logged by, Assignee, Reporter dimensions) which is currently using eazyBI
Syntax
CurrentUser()
Arguments
No arguments
Examples
The following formula is for calculated member in the Assignee dimension, which always returns the current user key value from this dimension.
If you select this calculated member in pages, the report will show information about issues assigned to the user who is logged in to eazyBI.
Aggregate(
[Assignee].[User].GetMemberByKey(
CurrentUser()
)
)
See report example Issues created vs resolved by priority in our Demo account. The calculated member Current Assignee in dimension Assignee uses the formula above to retrieve a logged in user. The formula for Current Assignee includes additional verification to validate if logged in user has any assigned issues to avoid any errors. You can select this calculated member on Pages to filter assigned issues to logged in user only.