Report Portal

Export Analysis services cubes, roles and members from a server to CSV using C#

At a customer we wanted to get an overview of all the roles and members of all his cubes at specific server. I decided to create a console application in C# that query’s the server using the SSAS management objects. Here you can find the code and download the program.

What it does is create a connection to the SSAS server and loop through all the databases, inside the database loop through the roles and all the members belonging to this role.

Make sure you reference the Analysis management objects to your project when you write your own code.



Tags: amo


2007-2015 VidasSoft Systems Inc.