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