Analysis Management Objects (AMO) 是SQL Server SSAS的对象模型库，通过它可以方便的对SSAS里的对象进行访问及控制，包括Cube,DataSource, DataSourceView, Partition, Measure, Dimension, Assembly, Role以及DataMining对象等。要使用它，必须在机器上找analysis management objects (amo) 是sql server ssas的对象模型库，通过它可以方便的对ssas里的对象进行访问及控制，包括cube,datasource, datasourceview, partition, measure, dimension, assembly, role以及datamining对象等。要使用它，必须在机器上找到ssas的安装路径microsoftsql server90sdkassemblies,把目录中的microsoft.analysisservices.dll文件加载到项目的reference列表中，amo对象就是通过这个dll文件进行访问的。
首先要添加引用using Microsoft.AnalysisServices;以下是测试用C#从SSAS中获取部分信息的源码：(代码中已经包含了较多的解释) using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using Microsoft.AnalysisServices;namespace AMOTest{class Program{static void Main(string[] args){string ConnecteString = "Data Source =ServerName; Provider=msolap";Server SSASServer = new Server();SSASServer.Connect(ConnecteString);List OutDatabase = GetDatabaseCollection(SSASServer);//show all database on the server Console.WriteLine("-------------Databse-------------------------------");for (int i = 0; i{Console.WriteLine(OutDatabase[i].Name.ToString());}//show the Cube of a database Console.WriteLine("---------------Cube--------------------------------");List OutCube = GetCubeCollection(OutDatabase[0]);for (int i = 0; i{Console.WriteLine(OutCube[i].Name.ToString());}//show all Roles of one database Console.WriteLine("---------------Roles_database-------------------------");List OutRole = GetRolescollection(OutDatabase[0]);Console.WriteLine(OutRole[0].Members.Count);//for (int i = 0; i//{// Console.WriteLine(OutRole[0].Members[i].Name);//}//show all Roles of one cube Console.WriteLine("---------------Roles_Cube----------------------------");List OutRole2 = GetRolescollection2(OutCube[0]);Console.WriteLine(OutRole2[0].Members.Count);//for (int i = 0; i//{// Console.WriteLine(OutRole2[0].Members[i].Name); //to show the detial of the role Members//}Console.Read();}//get the list of the database name static public List GetDatabaseCollection(Server server){List collectdb = new List();foreach (Database db in server.Databases){collectdb.Add(db);}return collectdb;}//get the list of a database cube name static public List GetCubeCollection(Database db){List collectcube = new List();foreach (Cube cube in db.Cubes){collectcube.Add(cube);}return collectcube;}//get the list of the database roles static public List GetRolescollection(Database db){List collectRoles = new List();foreach (Role cp in db.Roles){collectRoles.Add(cp);}return collectRoles;}//get the list of the cube Roles static public List GetRolescollection2(Cube cube){List collectionRoles = new List();foreach (CubePermission cp in cube.CubePermissions){collectionRoles.Add(cp.Role);}return collectionRoles;}}}这里需要说明的是，，当我获取Database的Roles和Cube的Roles值时，做了一个对比，他们的值是相同的。这可能的情况是，在Database中Cube只有一个，或者因为Cube隶属于database,他们的Roles值是相同的。