SSAS Tabular cube role will be accessed dynamically based on the user table

Sahoo 46 Reputation points
2021-08-25T13:00:52.48+00:00

Hi Team,

We have created one SSAS tabular cube and defined role in that cube.

Our Requirement is"

We are maintaining one sql server table for the users . Users will be added dynamically to the table whenever the new user inserted into the table then automatically same user will be accessed the role defined in the cube.

We don't have relation to cube tables and user table.

How can i achieve these one?

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,249 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,856 Reputation points
    2021-08-26T02:34:57.32+00:00

    Hi @Sahoo ,

    Dynamic security might be help you to achieve this. It is a technique that enables a single role to apply different permissions for different users. It’s useful when you would otherwise be forced to create and maintain a large number of individual roles. Please refer to Implement Dynamic Security by Using Row Filters to get more information.

    Best regards,
    Carrin


    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.

    0 comments No comments