Arquivo

Archive for the ‘Maintenance’ Category

List All SSAS Roles and Users Membership

This is a known issue of SSAS, there is no easy way to list all SSAS Roles and Users Membership in a Tabular and simple Format. There are some posts mentioning the use of Powershell in order to complete this task (

http://www.lucasnotes.com/2012/09/list-ssas-user-roles-using-powershell.html#comment-form). There is also a Roles Report available in Bids Helper but it hasn’t an easy and understandable format

However, with the help of a great project at codeplex called the Analysis Services Stored Procedure Project (http://asstoredprocedures.codeplex.com), we can install some stored procedures written in C# in our SSAS Server and then run this simple command in a Mdx query editor:

Command: call assp.discoverxmlmetadatafull(“\Database\Roles\Role|Name\Members\Member”)

The result:

apagarnov

Categorias:Maintenance