Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multiple Roles in one data connection (or duplicate reports instead) Expand / Collapse
Author
Message
Posted Wednesday, September 11, 2013 12:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 1, 2013 12:44 AM
Points: 7, Visits: 38
Hi,

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).

Thanks


Post #1493466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse