Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  composite rights using msas dimension security

Author  Topic  ramblk Starting Member 1 Post Posted - 2004-10-11 : 06:44:19 Hello, In my sales cube I have about 10 dimensions: vendors, materials, managers, stores etc. Generally, users needs to view information from one dimensions. So, using the role manager, I easily configure via custom dimension security. Examples (2 different users ): User No 1 views information only about vendors: "Sanitex", "Unilever". User No 2 views information only about stores: "Store No 300" and "Store No 555". my problem is: user No 3 is a head of users 1 and 2. he would like to see information about vendors ("Sanitex" and "Unilever") or (stores no 300 and store no 555). Is it possible to implement such composite security?? Have anybode some experience about that?? Ramunas