How to track the users inforamtion who all are accessing SSAS cube

Bala Narasimha Challa 466 Reputation points
2021-12-22T10:49:40.463+00:00

Hi Team,

Have multiple cubes deployed in analysis services and everyone connecting those cubes trough MS EXCEL.

Is their any option or possible to track who all are accessing cubes through MS EXCEL.

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,245 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,741 Reputation points
    2021-12-22T11:09:06.107+00:00

    You can use the build-in function OlapQueryLog, see Log operations in Analysis Services

    0 comments
  2. CarrinWu-MSFT 6,851 Reputation points
    2021-12-23T05:49:06.617+00:00

    Hi @Bala Narasimha Challa ,

    Thanks for your posting.

    Is their any option or possible to track who all are accessing cubes through MS EXCEL.

    To get a list for users currently connected to a SSAS instance via Excel, you might use SQL Server Profiler.
    159884-screenshot-2021-12-23-134253.png

    If you also would like to tracke users extended period of time, you can use Extended events.

    Best regards,
    Carrin

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    0 comments