SQL 2008 MDX 查询中的重复计算

Question

我有一个 MDX 查询，它返回以下元组：

Dim1A, Dim11, Dim21, Measure1A, Measure11, Measure21
Dim1A, Dim12, Dim22, Measure1A, Measure12, Measure22
Dim1A, Dim13, Dim23, Measure1A, Measure13, Measure23
Dim1A, Dim14, Dim24, Measure1A, Measure14, Measure24
....
....
Dim2A, Dim11, Dim21, Measure2A, Measure11, Measure21
Dim2A, Dim12, Dim22, Measure2A, Measure12, Measure22
Dim2A, Dim13, Dim23, Measure2A, Measure13, Measure23
Dim2A, Dim14, Dim24, Measure2A, Measure14, Measure24

Measure1A、Measure2A 对 Dim1A、Dim2A 重复，如果我有一个大集合，则查询响应时间会很慢，因为 MeasureA 是一项复杂的计算。我的问题是如何防止 MeasureA 对每个 DimA 计算 4 次。因此，在上面的示例中，Measure1A 被计算了 4 次，Measure2A 也被计算了 4 次。理想情况下，我希望为每个唯一的 DimA 计算一次

Answer 1

如果可能的话，您可以尝试使用查询范围的计算成员。只要您不在计算中包含当前成员，它就只会计算一次。这是否可行将取决于您的查询的复杂程度以及您是否有很多要添加的度量（Measure1A、Measure2A、Measure3A 等），

例如：

WITH 
   MEMBER [Measures].[Measure1a] AS ....your calculation....
SELECT 
 ..... your query