Share via

SSAS 2016 Role question

Uri Dimant 206 Reputation points
2020-09-29T05:59:45.013+00:00

Hello
We are using SSAS 2016 and I have question regarding the roles. I have created a simple role with filter for Employee Number , and if I test the role in Browse (SSAS) and select the role name it works just fine but it does NOT if I specify a another user (who is a member of the only this role and not admin), why it so?
Thanks

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,256 questions
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Uri Dimant 206 Reputation points
    2020-09-29T06:30:19.01+00:00

    Thank you Koen
    Only read permission I assigned to the role.

  2. Uri Dimant 206 Reputation points
    2020-09-29T06:54:39.973+00:00

    Dear Koen
    Yep this user is added to security role in the SSAS (Server Administrators), but if I remove it and leave him only in the Role members it throws the error that user does not have an access to the model.,.. What should I do?

  3. Uri Dimant 206 Reputation points
    2020-09-29T07:20:01.917+00:00

    Yep, one mote step forward :=)
    28980-image.png

    0 comments
  4. Uri Dimant 206 Reputation points
    2020-09-29T07:37:34.613+00:00

    Dear Koen
    It looks like I need to add Process permission to the use and remove it from the Server Admins role.