Analysis Management Objects (AMO) 是 SQL Server Analysis Services (SSAS) 的伺服器端物件模型組件,位於 Microsoft.AnalysisServices.dll。可用於:
Microsoft.AnalysisServices.dll(通常在 C:\Program Files\Microsoft SQL Server\xxx\SDK\Assemblies\)。using Microsoft.AnalysisServices;using System;
using System.Collections.Generic;
using Microsoft.AnalysisServices;
namespace AMOTest
{
class Program
{
static void Main(string[] args)
{
string connStr = "Data Source=ServerName; Provider=MSOLAP;";
var server = new Server();
server.Connect(connStr);
// 1. 列出所有資料庫
Console.WriteLine("----- Databases -----");
foreach (Database db in server.Databases)
Console.WriteLine(db.Name);
// 2. 取第一個資料庫的 Cubes
if (server.Databases.Count > 0)
{
var db = server.Databases[0];
Console.WriteLine($"\n----- Cubes in {db.Name} -----");
foreach (Cube cube in db.Cubes)
Console.WriteLine(cube.Name);
// 3. 資料庫層級角色
Console.WriteLine($"\n----- Database Roles in {db.Name} -----");
foreach (Role role in db.Roles)
Console.WriteLine($"Role: {role.Name}, Members: {role.Members.Count}");
// 4. Cube 層級權限 (CubePermission)
if (db.Cubes.Count > 0)
{
var cube = db.Cubes[0];
Console.WriteLine($"\n----- Cube Permissions in {cube.Name} -----");
foreach (CubePermission cp in cube.CubePermissions)
Console.WriteLine($"Role: {cp.Role.Name}, Members: {cp.Role.Members.Count}, Read: {cp.Read}, Write: {cp.Write}");
}
}
server.Disconnect();
Console.ReadKey();
}
}
}
database.Process(ProcessType.ProcessFull)、partition.Process(ProcessType.ProcessData)。role.Members.Add(new RoleMember("DOMAIN\Group"))。db.Backup("path.abf")、server.Restore("path.abf", "NewDB")。server.Traces、dimension.ProcessingState 等。Microsoft.AnalysisServices.Tabular)。MSOLAP,表格用 MSOLAP.8 (視版本)。