Hi,
My system consists of a Analysis Services 2000 OLAP database with
multiple cubes viewed via an OWC(11) tool.

I have a business requirement to restrict users to OLAP data that is
relevant to their area e.g. Austrian user may be member of a role that
will have read permissions on German and Austrian data

To implement this I tried both dimension and cell level security. On
both I had the problem that the restriction was only enforced when the
dimension referenced was active.

I have tried the following MDX at the Cell Level ;

iif( Ancestor([Sales Location].CurrentMember,
[Disti Top Prnt Sales Location]).Name = "Ireland", True,
False)

This only works where "Sales Location" is one of the active
dimensions.

Any ideas on how I can get this to work regardless of whether the
"Sales Location" has been selected or not?

Any help would be greatly appreciated.

Thanks,
Gerry