none
一个MDX计算成员的写法 RRS feed

  • 常规讨论

  • with
    member [cc] as   //本年累计。“本年中标,并且在统计区间已经签约”的客户数
    exists(
     filter(CROSSJOIN([DimCustomer].[Customer].ALLMEMBERS,
          [DimProjPhse].[Project Phase Level 2].&[2],   --已签约
          ancestor([DimTime].[Year - Week - Date].currentmember,[DimTime].[Year - Week - Date].[Year]).FIRSTCHILD
          :[DimTime].[Year - Week - Date].currentmember),
       [Measures].[Far Bid Invst Customer Qty] = 1  
     ),
     filter(CROSSJOIN([DimCustomer].[Customer].ALLMEMBERS,
          [DimProjPhse].[Project Phase Level 2].&[1],   --已中标
          ancestor([DimTime].[Year - Week - Date].currentmember,[DimTime].[Year - Week - Date].[Year]).FIRSTCHILD
          :[DimTime].[Year - Week - Date].currentmember),
       [Measures].[Far Bid Invst Customer Qty] = 1  
     )
    ).count

     

    这个MDX出不了正确结果,哪位指点一下,该怎么写

    2010年11月8日 2:14