Does anybody know if it is possible to change the cell security policy in a
cube role using DSO?
This sample comes from the BO, 'Working with Roles'
' Create a new cube role named TestRole, based on the database role
' named TestRole.
Set dsoRole = dsoCube.Roles.AddNew("TestRole", sbclsRegular)
' Change the role properties for the cube role.
' All of the other properties are propagated from the
' TestRole database role.
' Prevent the users associated with this role from
' reading the [Store Cost] measure.
.SetPermissions "CubeRead", _
"Measures.CurrentMember.Name <> ""[Store Cost]"""
The code example demonstrates the use of Multidimensional Expressions (MDX)
syntax to set cell security with the SetPermissions method of the Role
Quote:> Hi All,
> Does anybody know if it is possible to change the cell security policy in
> cube role using DSO?
Anyone who knows how to set the description field, using DSO, for a
certain MDX-expression regarding the cell security in Analysis
I want to have an automatic update function therefore it is not
possible to do this manually.
11. DSO and security