Hi,

I want to implement a dynamic security like we can do in AS2000.
I want to secure the customer name attribute of my customer dimension.

The user can see only the customer name if my "security" cube allow this.
My security cube has 2 dimensions:
* Users
* Customer

so, in this cube I have for each user the list of the authorized customers.

I create a new role, and I want to secure the customer dimension like:
exists([Customer].[Full Name].members, STRTOMEMBER( "Users.[User Name].&[" +
UserName + "]"))

but this doesn't works. (the expression is not valid)

can I do this without having to add my "security" cube in every cube I want
to secure?
can I secure the entire dimension (not by cube)?
how I have to write my MDX syntax?

thanks.

Jerome.