I need to implement dimension level security within a cube. Users need to be able to see only those members in a dimension that they have been given access to.
As far as I can tell, the preferred method of doing this dynamically is outlined here:
However, the use of a stored procedure seems rather hoky. Couldn't we use pure MDX to filter this instead? I apologize if this is not enough information, but I am a little fuzzy on dimension security post SQL2K.
Signature is NULL