I have an SSAS cube with 2 roles-
Agent Role- shows each sales agent his own deals only
Africa Role- shows only Africa deals (of all agents)
PPS dashboard based on each of the above seperately works fine.
We want certain sales agent to be able to see his own deals + all Africa deals.
So we gave him permissions to both roles in the cube.
When specifying both roles (with comma separation) in the same data connection, he is able to see all data!!
What is the solution for this?
Is there another way other than duplicating the whole dashboard and connecting the new dashboard to a different data connection with only single role? (it doesn’t sound good to duplicate items just for a different role connection).