In a dimension I have one attribute where the very same MEMBER_NAME occur for several members.
For example, all the following unique members share the same member_name "MyMember".
What I would like to do, in dimension security, for a specific role, for this specific attribute, is to make use of the MEMBER_NAME property when defining the allowed member set.
Like this: " all members with the MEMBER_NAME = "MyMember" " should be allowed.
Is this possible to do? If so, I would be really thankful for some help on how to write the correct MDX statement for this.