SSAS Live Connection - Filter for Current User

Anonymous tbh I'm not sure how that helps my sceanrio

let say you have 2 roles defined on the cube

1 Employee - where all data is filtered belonging a single employee via the employee Dimension (ie the person logged in)

2 Department Manager - where data is filtered by by it beloning to a particular department

I we have a user who is in both roles then the cube is going to allow them to see all their transactions and all transactions belonging to anyone in that department.

Therefore if they if they look at the report geared towards an individuals perfomances its going to returen datat belonging to all people in that department becasue there doen't appear to be anyway to dynamically filter it for just that users.

When they want to look at the department level perfmnce report yes they would want to see all the data broken down by different employees.

Using a LIve connection there just doesnt seem to be any way to dynamically filter that one persons data if they are allowed to see more than tat in the cube. If i've mis understood please could you procide an example of how it would work.

regards