Dimension Security - Multiple Roles

hi guys,

i working on implementing ssas dimension security.

i have following 2 roles on dimension security implemented on 2 different attributes ( city , country):

city_role = {[geography].[city].[city code]}
country_role = {[geography].[country].[country code]}

the first role restricted on cities , second restriced on countries.

scenario 1:

the user wants have access either on city or country level .we can map him corresponding role.so , user can see data authrozied see. not facing issues.

scenario 2:

the user wants have access on both city , country level. in case, have mapped him both roles. after which, whilst trying connect cube via excel, user can able see entire data irrespective of city , coutry mapped him per ex. incorrect.

for ex:
 city    : illinois
 country : london

please me in providing suitable solution scenario 2. let me know if unclear.

thanks in advance.

regards

ganesh

ganesh, 

are attribute relations set hierarchy? without them not possible. 

here place start if not sure. here

hope helps.

reeves

---

denver, co

SQL Server  >  SQL Server Analysis Services