I'm running SQL Server 2005 and have a need to permit a role to have access to a dimension attribute, but not be able to see the member values (we have drillthrough and report actions that include the attribute and some users need to see the member value, while others should not). Similar to masking a credit card number. In SQL I would do this via a case statement in a view or appending to a where clause in the appropriate semantic layer based on the group/role, but can't figure out a good solution for SSAS.

Has anyone been able to mask the member name data based on Role security settings? I've tried a combination of dimension data and cell level settings but thus far either end up being able to see the member values or get errors attempting the drillthrough action. I can always create two sets of actions/reports but would prefer to control this via role permissions.