使用Fill in ADOMD限制检索的行数

using Microsoft.AnalysisServices.AdomdClient;

// 创建连接字符串
string connectionString = "Data Source=YourServerName;Catalog=YourDatabaseName;";

// 创建连接
using (AdomdConnection connection = new AdomdConnection(connectionString))
{
    // 打开连接
    connection.Open();

    // 创建查询命令
    AdomdCommand command = new AdomdCommand("SELECT TOP 10 [Measure].[Sales] ON COLUMNS, [Product].[Product].Members ON ROWS FROM [YourCubeName]", connection);

    // 执行查询并获取结果
    AdomdDataReader reader = command.ExecuteReader();

    // 遍历结果
    while (reader.Read())
    {
        // 处理每一行数据
        // ...
    }

    // 关闭连接
    connection.Close();
}