WITH 
  --CstX_ Это множество клиентов, купивших за рассматриваемый интервал (в частном случае - месяц) определенное суммарное число кейсов 
  SET [CstX1] AS 'FILTER([Customers].[Groups and Customers].Members,[Measures].[Cases]>0 AND [Measures].[Cases]<=150)' 
  SET [CstX2] AS 'FILTER([Customers].[Groups and Customers].Members,[Measures].[Cases]>150 AND [Measures].[Cases]<=1000)' 
  SET [CstX3] AS 'FILTER([Customers].[Groups and Customers].Members,[Measures].[Cases]>1000 AND [Measures].[Cases]<=3000)' 
  SET [CstX4] AS 'FILTER([Customers].[Groups and Customers].Members,[Measures].[Cases]>3000)' 
  --SaleDomain Это множество "продажных ситуаций" (т.е. поле возможных продаж, образованное из всевозможных значений DIMs из "ключа" продажи) за рассматриваемый интервал (месяц) 
  SET [SaleDomain] AS 'Descendants([Time].[YMD].CurrentMember,[Time].[YMD].[Day])*[Products].[PG].[Description PG].Members*[Distribution].[Branch].Members' 
  --CstSaleX_ Это множество "продажных ситуаций" для клиентов CstX_ 
  SET [CstSaleX1] AS 'NonEmptyCrossjoin([SaleDomain],[CstX1],{[Time].[YQMWD].[All Time]},{[Time].[YWDD].[All Time]})' 
  SET [CstSaleX2] AS 'NonEmptyCrossjoin([SaleDomain],[CstX2],{[Time].[YQMWD].[All Time]},{[Time].[YWDD].[All Time]})' 
  SET [CstSaleX3] AS 'NonEmptyCrossjoin([SaleDomain],[CstX3],{[Time].[YQMWD].[All Time]},{[Time].[YWDD].[All Time]})' 
  SET [CstSaleX4] AS 'NonEmptyCrossjoin([SaleDomain],[CstX4],{[Time].[YQMWD].[All Time]},{[Time].[YWDD].[All Time]})' 
  --CstSale__ Это множество продаж клиентам группы CstX_, каждая из которых (продаж) состоит из определенного числа кейсов 
  SET [CstSale_раз1_сум1] as 'Filter([CstSaleX1],[Measures].[Cases]>0 AND [Measures].[Cases]<30)' 
  SET [CstSale_раз1_сум2] as 'Filter([CstSaleX2],[Measures].[Cases]>0 AND [Measures].[Cases]<30)' 
  SET [CstSale_раз1_сум3] as 'Filter([CstSaleX3],[Measures].[Cases]>0 AND [Measures].[Cases]<30)' 
  SET [CstSale_раз1_сум4] as 'Filter([CstSaleX4],[Measures].[Cases]>0 AND [Measures].[Cases]<30)' 
  SET [CstSale_раз2_сум1] as 'Filter([CstSaleX1],[Measures].[Cases]>=30 AND [Measures].[Cases]<300)' 
  SET [CstSale_раз2_сум2] as 'Filter([CstSaleX2],[Measures].[Cases]>=30 AND [Measures].[Cases]<300)' 
  SET [CstSale_раз2_сум3] as 'Filter([CstSaleX3],[Measures].[Cases]>=30 AND [Measures].[Cases]<300)' 
  SET [CstSale_раз2_сум4] as 'Filter([CstSaleX4],[Measures].[Cases]>=30 AND [Measures].[Cases]<300)' 
  SET [CstSale_раз3_сум1] as 'Filter([CstSaleX1],[Measures].[Cases]>=300 AND [Measures].[Cases]<=600)' 
  SET [CstSale_раз3_сум2] as 'Filter([CstSaleX2],[Measures].[Cases]>=300 AND [Measures].[Cases]<=600)' 
  SET [CstSale_раз3_сум3] as 'Filter([CstSaleX3],[Measures].[Cases]>=300 AND [Measures].[Cases]<=600)' 
  SET [CstSale_раз3_сум4] as 'Filter([CstSaleX4],[Measures].[Cases]>=300 AND [Measures].[Cases]<=600)' 
  SET [CstSale_раз4_сум1] as 'Filter([CstSaleX1],[Measures].[Cases]>600)' 
  SET [CstSale_раз4_сум2] as 'Filter([CstSaleX2],[Measures].[Cases]>600)' 
  SET [CstSale_раз4_сум3] as 'Filter([CstSaleX3],[Measures].[Cases]>600)' 
  SET [CstSale_раз4_сум4] as 'Filter([CstSaleX4],[Measures].[Cases]>600)' 
  MEMBER [Time].[YQMWD].[сум1] AS '1' 
  MEMBER [Time].[YQMWD].[сум2] AS '1' 
  MEMBER [Time].[YQMWD].[сум3] AS '1' 
  MEMBER [Time].[YQMWD].[сум4] AS '1' 
  MEMBER [Time].[YWDD].[раз1] AS '1' 
  MEMBER [Time].[YWDD].[раз2] AS '1' 
  MEMBER [Time].[YWDD].[раз3] AS '1' 
  MEMBER [Time].[YWDD].[раз4] AS '1' 
  MEMBER [Measures].[Колич, кл] AS 'Extract(StrToSet("[CstSale_"+[Time].[YWDD].CurrentMember.Name+"_"+[Time].[YQMWD].CurrentMember.Name+"]"),[Customers]).Count' 
  MEMBER [Measures].[Оборот, кс] AS 'Sum(StrToSet("[CstSale_"+[Time].[YWDD].CurrentMember.Name+"_"+[Time].[YQMWD].CurrentMember.Name+"]"),[Measures].[Cases])' 
  MEMBER [Measures].[Ср нац, %] AS ' 
    Sum( 
      StrToSet("[CstSale_"+[Time].[YWDD].CurrentMember.Name+"_"+[Time].[YQMWD].CurrentMember.Name+"]"), 
      [Measures].[Sell]-[Measures].[Store cost])/ 
    Sum( 
      StrToSet("[CstSale_"+[Time].[YWDD].CurrentMember.Name+"_"+[Time].[YQMWD].CurrentMember.Name+"]"), 
      [Measures].[Store cost])', FORMAT_STRING = 'Percent' 
  MEMBER [Measures].[Колич, дст] AS 'StrToSet("[CstSale_"+[Time].[YWDD].CurrentMember.Name+"_"+[Time].[YQMWD].CurrentMember.Name+"]").Count' 
  MEMBER [Measures].[Ср дост, кс] AS 'Avg(StrToSet("[CstSale_"+[Time].[YWDD].CurrentMember.Name+"_"+[Time].[YQMWD].CurrentMember.Name+"]"),[Measures].[Cases])' 
SELECT 
  {[Measures].[Колич, кл],[Measures].[Оборот, кс],[Measures].[Ср нац, %],[Measures].[Колич, дст],[Measures].[Ср дост, кс]} on columns, 
CrossJoin( 
  {[Time].[YWDD].[раз1],[Time].[YWDD].[раз2],[Time].[YWDD].[раз3], [Time].[YWDD].[раз4]}, 
  {[Time].[YQMWD].[сум1],[Time].[YQMWD].[сум2],[сум3],[Time].[YQMWD].[сум4]}) 
 on rows 
FROM [PG Sales] 
WHERE [Time].[YMD].[All Time].[ 2004 ].[ 04  - December]