FAQ: How do I Implement Conditional Security setting for Drill-Through Actions?

  • Article

Question

I created several Drillthrough Actions in my cube. The build-in function for Drillthrough is a high-level setting.  This means that an user can access to all actions or none. However, I would like to apply security settings for certain conditions.  

 

Answer

There is a Condition setting in a Drillthrough action definition. For example, If you want to grant permissions to one user, you can use an expression to check whether the current login account is the specific user.

Here are the steps:

  • 1. Double click the cube in BIDS project
  • 2. Switch to Actions tab, and click the target Action
  • 3. Then you will see a box named "Condition (Optional)", and input the expression below:

 UserName() = 'Domain\UserA'

 

Then only UserA can access to this Drillthrough action.