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

Question

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?

Answer 1

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.