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
Current user from the Assignee dimension
This formula is to create a calculated member in the Assignee dimension that always represents the current user. If you select this calculated member in pages, the report will show information about issues assigned to the currently logged-in user.
Aggregate( [Assignee].[User].GetMemberByKey( CurrentUser() ) )
Hours spent by the current user
The formula is asking for the hours spent by the currently logged-in user. This can be useful for creating personalized reports where users can see their own logged hours without needing to manually select their name from a list.
([Logged by].[User].GetMemberByKey(CurrentUser()), [Measures].[Hours spent])