question

MuhammadShami-2656 avatar image
0 Votes"
MuhammadShami-2656 asked LukasYu-msft answered

Find which user consumes the cube most often

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 ?

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.