Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Dynamic security using Security table in SSAS Tabular model Expand / Collapse
Posted Tuesday, June 24, 2014 10:17 AM


Group: General Forum Members
Last Login: Today @ 3:56 AM
Points: 10, Visits: 128

Platform : SSAS Tabular model (VS 2010)

I need to apply Dynamic security using Security table(manually created) in Tabular model, Need to apply filter for 2 tables. I am able to create roles in Tabular model using USERNAME() and LOOKUP() function it worked fine. But the problem is when i am trying to give full access for a particular column and limit the access in other column, it is not working properly.

Please find screenshot and guide me where i am falling short. In the Security table wherever you find ALL it means full access.

Do let me know if further explanations required.


  Post Attachments 
Security.png (10 views, 13.37 KB)
Post #1585584
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse