Hi, I'm looking at a SSAS Cube (version 2008) where I have made a role that has limited access to dimension. User in this role only gets a choose of 3 countries. But the problem is that I would like this limitation to be more general. For example if user chose All I would like that to mean just these 3 countries but now users get all data. And if the dimension is not used at all then no limitation is done.
So, how can I setup a more general filter that always will filter out these values?