MDX中的过滤条件

Question

你好，你能帮我弄一下MDX吗？我需要选择用于用户计数的措施。

SELECT 
  NON EMPTY 
    {
      [Measures].[User count]
     ,[Measures].[User count oM]
     ,[Measures].[User count oQ]
     ,[Measures].[User count oY]
    } ON COLUMNS
FROM [User count]
WHERE 
  (
    [Subscription tier].[Subscription tier].&[1]
   ,StrToMember("[Fordate].[YQMD].[Date].[" + Format(Now() - 1,"yyyy-MM-dd") + "]")
   ,{
      [Product].[Finance Group].&[3]
     ,[Product].[Finance Group].&[6]
     ,[Product].[Finance Group].&[8]
     ,[Product].[Finance Group].&[2]
     ,[Product].[Finance Group].&[9]
     ,[Product].[Finance Group].&[1]
    }
  );

这个很管用。我需要在这个工作的MDX中添加如下条件：

if [Product].[Finance Group].&[1] then filter
[Version].[Version subgroup].&[AVG 2012] 
+[Version].[Version subgroup].&[AVG 2013] 
+[Version].[Version subgroup].&[AVG 2014] 
+[Version].[Version subgroup].&[AVG 2015]
+[Version].[Version subgroup].&[AVG 2016]
+[Version].[Version subgroup].&[AVG 7-10]

Answer 1

我刚找到答案。也许它会帮助别人：-)

with member [Version].[Version subgroup].[x] as
      [Version].[Version subgroup].&[AVG 2012]
     +[Version].[Version subgroup].&[AVG 2013]
     +[Version].[Version subgroup].&[AVG 2014]
     +[Version].[Version subgroup].&[AVG 2015]
     +[Version].[Version subgroup].&[AVG 2016]
     +[Version].[Version subgroup].&[AVG 7-10] 

    member a as
         ([Version].[Version subgroup].[x]
         ,[Measures].[User count])

    member a1 as
         ([Product].[Finance Group].&[1],a)

    member[Product].[Finance Group].[x] as
          [Product].[Finance Group].&[3]
         +[Product].[Finance Group].&[6]
         +[Product].[Finance Group].&[8]
         +[Product].[Finance Group].&[2]
         +[Product].[Finance Group].&[9]

    member b1 as
         ([Product].[Finance Group].[x]
         ,[Measures].[User count])

    member final as a1+b1

 SELECT
 NON EMPTY 
 {
  [Measures].[User count], 
  [Measures].[User count oM], 
  [Measures].[User count oQ], 
  [Measures].[User count oY]
 } ON COLUMNS
  FROM [User count]
  WHERE ([Subscription tier].[Subscription tier].&[1]
   , StrToMember("[Fordate].[YQMD].[Date].["+Format(Now()-1,"yyyy-MM-dd")+"]") 
   ,[User type].[User type].&[1]
     )