MDX计算成员性能问题

可以通过在查询中使用SCOPE语句或者在Cube设计中使用预聚合表等方法来优化计算成员的性能。

示例代码：

1. 使用 SCOPE 语句来优化计算成员：

WITH MEMBER [Measures].[Avg Sales per Category] AS AVG([Product].[Product Categories].[Product Category].MEMBERS, [Measures].[Sales Amount])

SELECT [Measures].[Avg Sales per Category] ON 0, [Product].[Product Categories].[Product Category].MEMBERS ON 1 FROM [Adventure Works]

-- 使用 SCOPE 语句 SCOPE ([Measures].[Avg Sales per Category], [Product].[Product Categories].[Category].MEMBERS); THIS = AVG([Product].[Product Categories].CURRENTMEMBER, [Measures].[Sales Amount]); END SCOPE;

2. 在 Cube 设计中使用预聚合表来优化计算成员：

CREATE AGGREGATION [Avg Sales by Category Agg] FOR [Measures].[Avg Sales per Category] AS ( AGGREGATE([Product].[Product Categories].[Product Category].MEMBERS, [Measures].[Sales Amount]) );

然后在查询中使用该聚合表：

SELECT [Measures].[Avg Sales per Category] ON 0, [Product].[Product Categories].[Product Category].MEMBERS ON 1 FROM [Adventure Works] WHERE ([Avg Sales by Category Agg]);