Friday, February 24, 2012

Domain groups disabled by default. how to enable them by default?

Hello,

I notticed that to add a domain global group to a role, you first have to enable this type of object.

Also, I did convert a few cubes from 2000. I have a lot of domain groups associated with a lot of roles, the problem here is that the membership shows a UID instead of the group name because the group object is disabled.

1) How could I have the domain group object enabled by default in a new cube

2) How could I have te domain group object enabled in all existing roles so the system would be able to resolve them?

3) Where would be the place to find documentation and examples for the replacement of the old DSO that I was using to script my 2000 cubes.

Thanks,

Philippe

I beleive you a bit mistaken with what is going on.

The membership pane in Roles editor is invoking OS dialog when you try to add a user to a role. That is the same dialog you will see when you for instance try to change folder permissions in your hard drive.

What you can do is to open your database in SQL Management studio, click on the role you interested and then click on the Script. You will see XMLA script that you can use to change memebership in the role. You can manually change it to update group names. Analysis Server is agnostic to the name of the member. It will try to resolve it using windows API. Make sure you use domainname\username or domainname\groupname for members names in a role.

In Analysis Serivces 2005 you will use AMO object model to mange objects. But if you need a simple scripting solution, you might be fine with just using XMLA scripts.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

No comments:

Post a Comment