Bill,

Thanks for the info. Unfortunately it is necessary to do this within the cube itself via the drillthrough action and roles. We have a 3rd party application that leverages the drillthrough functionality so adding the reporting services layer won't work in this particular instance. The users do their slice-and-dice analysis and then can execute a predefined drillthrough action to view detail. Otherwise, using reporting services would certainly allow for the data masking.

Thx!

John