I need to restrict a dimension and have 150 or so roles that need to be
created. This is obviously a nightmare in terms of maintenance so I am
looking at the Dynamic Security options. I need multiple users in each
role and am struggling with this in terms of the mdx. Can anyone help?

There is a way with UDF dynamic security.
basically, you need to create dll for returning role according its security
level
and its method should be called from Role difinition.
Please search web and you can find it.


"wall.andrew (AT) gmail (DOT) com" wrote: