Hey,<br><br>I'm having a problem using the Decision Support Object in VB to limit users' views of the data. I have created a Visual Basic app. to set the permissions, but it isn't doing what I want it to do. Here's the permission expression:<br><br>sPermission = "Iif(Ancestor(Current.Member, Mgr.Name = ""BobW"", 1, 0)"<br>dsoRole.SetPermissions "CellRead", sPermission<br><br>If anyone can tell me why this isn't working, It would be very helpful. <p>Jackson C. Cooper<br><a href=mailto:jacksonc@orrcorp.com>jacksonc@orrcorp.com</a><br><a href= > </a><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using DSO to manage cell-level security
- Thread starter JCC
- Start date
Jackson,
Your permission string should be in the following format:
"Iif(Ancestor([DIMENSION_NAME].CurrentMember,[LEVEL_NAME]).Name=""MEMBER_NAME""
,1,0)"
As an example on the Foodmart sample database, the following statement would limit access only to those members in the Customers dimension below the "BC" State Province in Canada:
"Iif(Ancestor([Customers].CurrentMember,[State Province]).Name=""BC"",1,0)"
Hope his helps,
Jason.
Your permission string should be in the following format:
"Iif(Ancestor([DIMENSION_NAME].CurrentMember,[LEVEL_NAME]).Name=""MEMBER_NAME""
,1,0)"As an example on the Foodmart sample database, the following statement would limit access only to those members in the Customers dimension below the "BC" State Province in Canada:
"Iif(Ancestor([Customers].CurrentMember,[State Province]).Name=""BC"",1,0)"
Hope his helps,
Jason.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question