Dynamic security using Security table in SSAS Tabular model

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply