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 |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2004-04-09 : 03:36:35
|
| Hi,I have defined server side roles and have tried to restirct some users to see only partial data e.g. I have a Product dimension ( ProdCategory, ProdFamily, etc.) and selected one of the ProdCategory for the user.Then I tried to process the cube and it gave me an error something like the'top visible level must have unique names....' so I went to edit the the Product Dimension and in the advanced propert for ProdCategory set the 'Member Names Unique' property to TRUE (the default was FALSE)... then I processed the dimension and them the cube (I selected the rebuild option and not the incremental)....all went okay so far... I even tested the rule and it was showing data as I was expected after applying the rule...BUT when I tested browsing the cube at the client side, the role restriction does not seem to have been applied.Can someone please help me out. Thanks Thanks & Regards.-J |
|
|
|
|
|
Roles defined on a Cube are not working - Urgent