468,532 Members | 1,866 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,532 developers. It's quick & easy.

Security with SSAS 2005

1
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 divisions, services and CC.
In the role 2 Alice can see one specific division of dept1, let's say div1, with all its services, and CC.

When Alice browse the cube via Excel tool, there is a strange behavior, if she drag & drop the whole hierarchy of my dimension she can see dept1 with all its divisions, services and so on (role 1). It's the behavior I was expecting the roles are additive.

However if she only drag & drop CC attribute she can see only what is allowed by role 2, i.e., CC related to divi1. If she drag & drop service attribute she still see only what is allowed by role 2, i.e., services related to div1 only. Once she drag & drop department attribute she can see all divisions related to role1. It seems the roles are restrictive and at some stage they become additive???

Any ideas?
Thanks
Assia
Jun 25 '07 #1
0 1002

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

15 posts views Thread by osfwofujro | last post: by
5 posts views Thread by Norsoft | last post: by
4 posts views Thread by Henrik Skak Pedersen | last post: by
5 posts views Thread by VictorG | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.