locked
Dynamic Row Level Security RRS feed

  • Question

  • I am looking to extend our role based security to be more flexible to users who are able to see more of our employee hierarchy.  We have a User Role, with row level security that filters the list of employees to those who have the users ID in the Hierarchy PATH value.  However for senior users who can see almost all of the employee hierarchy it becomes difficult to filter to a specific set of employees.  

    Does anyone know how to create a filter that allows a senior user to make a connection to SSAS as a specific user? i.e. can you combine the UserName and CustomData parameters on a connection to further filter the row level security to a specifically selected user?

    Or alternatively can a drop down in a report in Powerview / Powerpivot be used to select a different user to filter the employees based on a PATHCONTAINS measure?

    Thanks

    Monday, November 18, 2013 2:57 PM

Answers