结合了两个计算的度量并使用组合结果MDX

Question

我正在创建两个不同的计算方法，我想使用两者的结果从同一立方体中计算出一个查询的度量。

创建的计算方法之一是 -

With Member [Measures].[VenueSalesCost]
 as
 (
 [Measures].[Amount - Reporting Currency]
)
Select [Measures].[VenueSalesCost]
 on columns
 from  [Project accounting cube]
where 
[Chart of accounts].[Main account name].&[Venue Hire Costs]

，第二个是 -

 With Member [Measures].[VenueSalesAmount]
as (
[Measures].[Amount - Reporting Currency]
)
 Select [Measures].[VenueSalesAmount]
 on columns
 from  [Project accounting cube]
where 
[Chart of accounts].[Main account name].&[Rental of Venue]

现在我想在查询中使用两个措施。请让我知道如何结合两种措施。

Answer 1

只需将不同查询的WHERE条件移动到计算方法的定义元组中：

With Member [Measures].[VenueSalesCost]
     as
     (
     [Chart of accounts].[Main account name].&[Venue Hire Costs],
     [Measures].[Amount - Reporting Currency]
     )
     Member [Measures].[VenueSalesAmount]
     as 
     (
     [Chart of accounts].[Main account name].&[Rental of Venue],
     [Measures].[Amount - Reporting Currency]
     )
     Member [Measures].[new Measure]
     as 
     [Measures].[VenueSalesCost] - [Measures].[VenueSalesAmount]
Select {
       [Measures].[VenueSalesCost],
       [Measures].[VenueSalesAmount],
       [Measures].[new Measure]
       }
       on columns
 from  [Project accounting cube]