We are trying to implement dynamic dimension security by creating a
custom rule. The problem is we have many distinct count measures in
our virtual cubes. Disabling Visual Totals is a security hole and is
not an acceptable solution to us. I would like to be able to enable
visual totals but get #ERR for the distinct count measures at the
'ALL' level. I understand why distinct counts and visual totals do not
work. Is there a workaround someone has found.

I would appreciate any help or suggestions. Thanks.