DrillThrough Actions and (semi) Security in SSAS OLAP cubes
Using SSAS 2005/2008, there is no way to apply security to DRILLTHROUGH actions, so we cannot decide whether a specific user is authorized or not to perform a specific action. This is a “by design” behavior, since DRILLTHROUGH actions are initiated at the client side, we can decide whether a user can perform or not DRILLTHROUGH but, once we let him do it, he can query anything he wants.
Nevertheless, if we are not concerned with security but only with user experience, there is a simple trick to define which users can see which actions.
Tags: security, action, drillthrough