Performance issues with CurrentUser()

Testing has indicated that sluggish EazyBI performance is caused by utilizing the CurrentUser() function as a calculated member in the Assignee dimension:

— Current Logged-in User
Aggregate(
IIF( IsEmpty([Assignee].[User].getMemberByKey(CurrentUser())),
{},
[Assignee].[User].getMemberByKey(CurrentUser())
)
)

Any suggestions on resolving this performance issue while retaining CurrentUser() functionality will be greatly appreciated

@AWPPMT

The “Current user” (in the way you defined) alone in the report should not affect the performance of a report.

But you can try simpler version of the formula for your report:

Aggregate(
[Assignee].[User].Members.item(
  CurrentUserName()
))

If that didn’t help please reach out to support@eazybi.com and provide report definition exported to a text file

Martins / eazyBI