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??