两种不同维数的计算测量与滤波

Question

这行得通

WITH MEMBER [Measures].[Pre] AS
SUM
(
-{
[Dim Event].[Ticket].&[Open]
},
(
[Measures].[Event Incidents Count]
)
)
Select  [Measures].[Pre] on 0
From Event 

但是，添加另一个维度，如

WITH MEMBER [Measures].[Pre] AS
SUM
(
-{
[Dim Event].[Ticket].&[Open]
,[Dim Category].[Status].&[OPEN]
},
(
[Measures].[Event Incidents Count]
)
)

Select  [Measures].[Pre] on 0
From Event 

导致了这个错误，

执行查询..。成员、元组或集合必须在函数中使用相同的层次结构。执行完成

如何重写第二个查询，使之具有两个维度。顺便说一句，这是用于立方体计算的，所以我只使用这样的方法

SUM
(
-{
[Dim Event].[Ticket].&[Open]
,[Dim Category].[Status].&[OPEN]
},
(
[Measures].[Event Incidents Count]
)
)

更新:解决方案

WITH MEMBER [Measures].[Pre] AS
SUM
(
CROSSJOIN(
- {
[Dim Event].[Ticket].&[Open] }
, - { [Dim Category].[Status].&[OPEN] }
)
,
[Measures].[Event Incidents Count]
)

Answer 1

试试这个，可能有用..。

SUM
(
-{
[Dim Event].[Ticket].&[Open]
},
{
[Dim Category].[Status].&[OPEN]
},
(
[Measures].[Event Incidents Count]
)
)

Answer 2

WITH MEMBER [Measures].[Pre] AS
SUM
([Dim Event].[Ticket].&[Open] * [Dim Category].[Status].&[OPEN],
([Measures].[Event Incidents Count])
)

Select  [Measures].[Pre] on 0
From Event

帮帮忙！