none
SSAS Tabular : User in two security roles with rows security filters and object-level security filters RRS feed

  • Question

  • I am implementing a dynamic filter in roles that I have in my SSAS Tabular cube. I have a user that is in two different roles.

    If I test my data using this user only in one role everything returns as expected, but if the user is in two different roles I get the following error.

    The combination of active roles results in a dynamic security configuration that is currently not supported. Please contact the administrator of the database to resolve this issue. (Microsoft SQL Server 2017 Analysis Services)

    I have rows security filters and object-level security filters.

    This error appears to anyone? Anyone knows how to pass through this issue?

    Thanks for all your help.


    -- Ricardo Castro

    Thursday, October 29, 2020 1:54 PM

All replies

  • Hello Ricardo,

    This forum is dedicated to supporting issues related to open specification. You can access open specifications at https://docs.microsoft.com/en-us/openspecs/. Your inquiry does not seem to be related to open specifications.

    For a better chance of getting an answer to your question, you may want to post your question to the following forum:

    https://docs.microsoft.com/en-us/answers/products/sql-server

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open Specifications
    Thursday, October 29, 2020 3:41 PM
    Moderator
  • Thanks  S Nadendla,

    I Will Open this question on the forum you sugest.

    Regards


    -- Ricardo Castro

    Thursday, October 29, 2020 7:31 PM