MDX过滤器”条件不工作

Question

现在我的问题是 MDX 查询中的过滤条件。我使用的 MDX 查询如下所示。

SELECT
NON EMPTY { [Channel].[Grand Total],
            [Channel].[Grand Total].Children } ON COLUMNS,
NON EMPTY { [Offer].[Grand Total],
            [Offer].[Grand Total].Children } ON ROWS 
FROM
  [SCMAircelCube]
WHERE
( [Measures].[TotalCount], 
  [BasicCause].[Subscriber activated successfully] ,
  [SubscriberProfile].[Active], 
  [Circle].[ASSAM])

此查询的问题是，这显示以“AOL”开头的报价。实际上我不想在报告中显示该报价。所以我我正在尝试使用 FILTER 条件。但它也不起作用。我收到错误。任何人都可以帮助我 我想在 ROWS 上使用过滤条件。我使用以下 MDX 进行过滤。但错误正在得到

SELECT
NON EMPTY { [Channel].[Grand Total],
            [Channel].[Grand Total].Children } ON COLUMNS,
FILTER( { [Offer].[Grand Total],
          [Offer].[Grand Total].Children !=[AOL]} ) ON ROWS
FROM
  [SCMAircelCube]
WHERE
( [Measures].[TotalCount], 
  [BasicCause].[Subscriber activated successfully] , 
  [SubscriberProfile].[Active], 
  [Circle].[ASSAM])

感谢和问候 请帮助我

Answer 1

您的 filter mdx function 是否最有可能导致该问题，您可以吗尝试使用类似的内容：

FILTER( { [Offer].[Grand Total],[Offer].[Grand Total].Children}, 
        [Offer].[Grand Total].currentmember is not [Offer].[Grand Total].[AOL] )

作为对您评论和修复括号问题的回答：

SELECT 
 { [Channel].[Grand Total], [Channel].[Grand Total].Children } ON COLUMNS, 
 FILTER ( {[Offer].[Grand Total], [Offer].[Grand Total].Children }, 
   not([Offer].[Grand Total].currentmember is [Offer].[Grand Total].[AJOKED]) ) ON ROWS
FROM [SCMAircelCube] 
WHERE ( [Measures].[TotalCount], [Time].[2012].[1], [BasicCause].[Subscriber activated successfully], [ContentCategory].[SMS], [SubscriberProfile].[Active], [Circle].[KARNATAKA])

Answer 2

您可以使用 EXCEPT 函数：

SELECT
NON EMPTY { [Channel].[Grand Total],
            [Channel].[Grand Total].Children } ON COLUMNS,
 { [Offer].[Grand Total], EXCEPT({[Offer].[Grand Total].Children}, {[Offer].[Grand Total].[AOL]})}  ON ROWS
FROM
  [SCMAircelCube]
WHERE
( [Measures].[TotalCount], 
  [BasicCause].[Subscriber activated successfully] , 
  [SubscriberProfile].[Active], 
  [Circle].[ASSAM])