Dynamic security in a tabular model for analysis services

The second iteration of the tabular model for analysis services now allows us to implement very sophisticated security scenarios including row-level dynamic security. 

In order to implement it, first we need the means of finding out the windows credentials of the user.  That can be accomplished using the DAX function USERNAME(). Second, we need to map windows credentials with the desired functionality we are trying to secure.  Third, we need the means to dynamically lookup that security logic in our map.  That can be done using the DAX function LOOKUPVALUE()

Please follow this link for additional information.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s