December 2, 2011 at 6:33 am
hi
a simple question (yes i've tried googling, no luck!)
i want to silo my cube between three network groups
North - who can only see North data
South - who can only see south
All - who can see both
so...how do i do that and do i need Enterprise edition?
thanks in advance
December 19, 2011 at 12:14 pm
darth_vodka (12/2/2011)
hia simple question (yes i've tried googling, no luck!)
i want to silo my cube between three network groups
North - who can only see North data
South - who can only see south
All - who can see both
so...how do i do that and do i need Enterprise edition?
thanks in advance
The easiest way would be to setup 3 AD (active directory) groups and add the user accounts to the groups. Then you can add 3 roles to you cube (1 for each AD group) and setup security as needed for each group...
Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com
December 20, 2011 at 2:30 am
iPolvo (12/19/2011)
darth_vodka (12/2/2011)
hia simple question (yes i've tried googling, no luck!)
i want to silo my cube between three network groups
North - who can only see North data
South - who can only see south
All - who can see both
so...how do i do that and do i need Enterprise edition?
thanks in advance
The easiest way would be to setup 3 AD (active directory) groups and add the user accounts to the groups. Then you can add 3 roles to you cube (1 for each AD group) and setup security as needed for each group...
aha, many thanks
roles are Enterprise aren't they?
December 21, 2011 at 5:46 am
No roles are for both editions. You assign each role to specific set of data within your dimensions.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply