在MDX中为一组成员创建度量值

Question

我需要以下东西：

with member Measures.Test2 as (Measures.Test, {[Assets Monthly].[Disbursed Date].&[2014], [Assets Monthly].[Disbursed Date].&[2015]})
select Measures.Test2 on columns
from databaseX

只有当我只设置一个成员时，它才有效，例如：

with member Measures.Test2 as (Measures.Test, [Assets Monthly].[Disbursed Date].&[2014])

我在第一种情况下得到的错误是：

函数需要一个字符串或数值表达式论点使用了元组集表达式。

Answer 1

对抗AdvWrks:

WITH 
  MEMBER Measures.Test2 AS 
    Sum
    (
      {
        [Date].[Calendar].[Calendar Year].&[2006]
       ,[Date].[Calendar].[Calendar Year].&[2007]
      }
     ,[Measures].[Internet Sales Amount]
    ) 
SELECT 
  Measures.Test2 ON COLUMNS
FROM [Adventure Works];

您的脚本：

WITH 
  MEMBER Measures.Test2 AS 
    Sum
    (
      {
        [Assets Monthly].[Disbursed Date].&[2014]
       ,[Assets Monthly].[Disbursed Date].&[2015]
      }
     ,Measures.Test
    ) 
SELECT 
  Measures.Test2 ON COLUMNS
FROM databaseX;

这更漂亮。在Date层次结构上创建了一个计算成员，并将度量值丢弃在WHERE切片器中：

WITH 
  MEMBER [Date].[Calendar].[testPeriod] AS 
    Aggregate
    (
      {
        [Date].[Calendar].[Calendar Year].&[2006]
       ,[Date].[Calendar].[Calendar Year].&[2007]
      }
    ) 
SELECT 
  [Date].[Calendar].[testPeriod] ON COLUMNS
FROM [Adventure Works]
WHERE 
  [Measures].[Internet Sales Amount];