April 21, 2012 at 1:50 pm
I have 5 cubes, and hierachy defined for all cubes. for example:
geography database with 5 continents as cubes and contries as dimensions.
Now when i am doing security restrictions on my dimension ex: In USA
dimension if i want only to give access to
texas region then i should be able to see only texas cities. But i can
see all the states under USA even after
selecting only Texas region under Dimension data tab inside ROles
section in SSMS.
I have tried security at database ,cube level as well as dimension
level.But still not working.
is that because of some wrong design of cubes or something related to
database design.?
I am not able to undersand that except roles everything in my cubes or
datawarehouse is working fine without and
defect in data.
Any suggesions....
April 21, 2012 at 5:04 pm
How are you testing? If you're trying to test using your admin account, you'll see everything.
Steve.
April 22, 2012 at 3:48 am
I m testing in excel as well as changing user account in browsing cube. I am using my account in office and i am checking all this on a remote system.
April 23, 2012 at 4:57 am
Try clicking Test Cube Security on the Cell Security tab. I found that necessary even though I wasn't using cell security. It's not at all an intuitive step and only came across it trying every possible thing.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply