Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Tuesday, June 24, 2014 10:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 7:28 AM
Points: 8, Visits: 77
Hi,

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.

Thanks,
Sundar



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

Add to briefcase

Permissions Expand / Collapse