CODEWITHSUNDEEP
sqlssasssas-tabular
Henry
Henry

Reputation: 167

SSAS TAbular Role hide some of tables

I have some tables in my SSAS Tabular, but I want to hide some table for certain user. Ex : I have Sales, Bonus, and master tables. For Operation Department user cannot see bonus's table.

Upvotes: 2

Views: 1444

Answers (1)

vercelli
vercelli

Reputation: 4757

Create a Read role for those users/groups. Use the row filter =FALSE() on any column of the tables you want to hide. No rows on those tables will be available to those users.

If you don't want them to see the dimension at all create a perspective that doesn't include the tables (in addition to the create role).

Upvotes: 2

Related Questions