Analysis Services Roles

Last Post 17 Jul 2008 02:03 AM by dale123. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

17 Jul 2008 02:03 AM
I have a task of getting a list of all the users who are in the AS roles on our cube server - I'm not very familiar with AS but I am with SQL Server OLTP.

Is there a way i can write a query to tell me who is in the role instead of having to manually use the gui and write down all the usernames. The equivalent for sp_helprolemember or sp_helpsrvrolemember but for Analysis Services (MDX) ????

Thanks in advance

Acceptable Use Policy