How to get the users using cube frequently

KamiFen 121 Reputation points
2020-10-02T07:45:16.577+00:00

Hi ,
I want to get list of users who access cube regularly.
With my very limited understanding I was thinking to run Profiler on server for few days to get the list of users. Is this the right option?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-10-02T08:17:26.807+00:00

    Hi,

    You could check this article that may help: Audit Log for Analysis Services
    For more details you could see official doc : Log operations in Analysis Services

    Regards,
    Lukas

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Olaf Helper 44,501 Reputation points
    2020-10-02T11:56:58.257+00:00

    I also suggest using Log operations in Analysis Services , it's more lightweight then traces.

    Later you can analyze the log in table OlapQueryLog with this script: Basic OlapQueryLog Analysis

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.