Find which user consumes the cube most often

Question

Hi ,
I want to know the user usage and find out the top users. I was thinking to run Profiler on server for few days to get the list of users. is this the right option? If yes please could you suggest me any tutorial link for this ? And if not then using what other ways i can use ?

Answer 1

Hi,

For this requirement, you could audit the SSAS server. Try checking this artickle : Audit Log for Analysis Services

Also you could find help in the SSAS official doc : Log operations in Analysis Services

Regards,
Lukas