MDX 查询中Where 子句的比较

Question

在 MDX 查询中，如何比较级别值是否小于某个值。 例如，

SELECT NON EMPTY
    [Sales Territory].[Sales Territory Country].Members ON 0,
    [Product].[Category].[Clothing] ON 1
FROM
    [Adventure Works]
WHERE
    ([Measures].[LowGPM] > 120)

此 MDX 查询不起作用。

另外，我也尝试过WITH子句。

WITH Member [Measures].[Calculated Measures] as
     IIF ([Measures].[LowGPM] < 120, [Measures].[LowGPM], null)

SELECT NON EMPTY
    [Sales Territory].[Sales Territory Country].Members ON 0,
    [Product].[Category].[Clothing] ON 1
FROM
    [Adventure Works]
WHERE
    ([Measures].[LowGPM] > 120)

它显示 Mondrian 错误：在多维数据集中找不到 MDX 对象“[Measures].[Calculated Measures]”。

Answer 1

您可以像这样过滤轴：

SELECT
  [Measures].[Internet Sales Amount] ON 0,
  Filter(
    [Customer].[Country].Members, 
    ([Measures].[Internet Sales Amount] > 2000000) 
        AND ([Measures].[Internet Sales Amount] < 5000000)
  ) ON 1
FROM [Adventure Works]