Hello,

I have a question concerning security in SSAS 2005. I create two roles, let's say, role 1 and role 2. I have a user, let's Alice that belongs to the two roles.
These roles are set on one specific dimension of my cube. This dimension is organized as hierarchy: Sector, department, division, service and the last level which is called CC.

In role 1 Alice can see one department (let's say dept1) with all its...