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