Hi

I want to secure a dimension by user.
I have 2 formulas, the first works fine but not the second, why?
working:
nonempty([Employee].[Full Name].members,
crossjoin(strtomember("[Users].[User Name].&[" + UserName + "]"),
measures.[Security Employee Count]))

Not Working:
exists([Employee].[Full Name].members, strtomember("Users.[User Name].&[" +
UserName + "]"), "Security Employee")

the Security Employee measure group contain only the Security Employee Count
measure.

also, I have to apply this security to each cube.
does it possible to apply this security at the dimension level, not for each
cube?
if yes, how?

thanks.

Jerome.