Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottichrosaviakosmos
Yak Posting Veteran
66 Posts |
 Posted - 2012-04-21 : 16:01:55
|
| 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 USAdimension if i want only to give access totexas region then i should be able to see only texas cities. But i cansee all the states under USA even after selecting only Texas region under Dimension data tab inside ROlessection in SSMS.I have tried security at database ,cube level as well as dimensionlevel.But still not working.is that because of some wrong design of cubes or something related todatabase design.?I am not able to undersand that except roles everything in my cubes ordatawarehouse is working fine without anddefect in data.Any suggesions....scoo |
|
|
|
|
|
SSAS Dimension Data for Roles not working