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.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 DSO for defining Cube Roles

Author  Topic 

jojo_jacob
Starting Member

24 Posts

Posted - 2004-08-09 : 10:32:51
Is it possible to use DSO objects to programmatically set the dimension level security? In a hierarchical dimension in a cube, I want to give the users different levels of access. For one user, one level is not accessible while a second user can access the same level. This can be done using the Analysis Manager, but I need to set it up dynamically from a front end application. Please help with a sample code if possible. Thanks very much.
Jojo
   

- Advertisement -