MDX 查询问题

Question

我是 MDX 新手。我正在尝试执行以下结果。

Attended Client Count              Client Count

---------------------             -----------------

723                                  1223

我尝试这样做：

WITH MEMBER [Attended Client] AS
        [Measures].[Client Count]

SET [Attended Client Set] AS
FILTER
(
    [Dim Client Attendance].[Attended].&[Attended],
    [Measures].[Client Count] <>0
)

SELECT {[Measures].[Client Count],[Attended Client] } ON COLUMNS
FROM [Client Intervention]

它引发了一个错误：函数中指定的两个集合具有不同的维度。我可以一次执行[措施].[客户计数]或[出席的客户]，但不能一起执行。有什么解决办法吗？谢谢

Answer 1

这里有一个关于 MDX 的简单介绍的链接，您可以在其中了解寻找元组/集合。以下查询应该执行您想要的操作：

WITH MEMBER [Measures].[Attended Client Client] AS
  Aggregate( FILTER ( 
               [Dim Client Attendance].[Attended].&[Attended], 
               [Measures].[Client)Count] <>0
             ),
             [Measures].[Client Count]
  )

SELECT {[Measures].[Attended Client Client],[Measures].[Client Count] } ON COLUMNS
FROM [Client Intervention]