I've been trying to use CustomData to provide the logged-in user's e-mail ID so that I could filter cube data based on that CustomData value.
The problem is that if I use CustomData then the EffectiveUsername is the OLAP Administrator (which is what is configured in the gateway's cube data source). This completely bypasses any cube security.
If, however, I use EffectiveUsername instead of CustomData, I only see the email in Profiler logs but what I see in the USERNAME field is DOMAIN\USER not the e-mail of the user accessing the cube?
Does anyone know of a way to access the logged in user's e-mail from the cube or is there any way the SSAS cube can be accessed without using an administrator account for the data source credentials?