MDX tips - 9dian/Index GitHub Wiki

with member [日期].[时间段合计] as 'Sum(([日期].[2018].[1].[20180101] : [日期].[2018].[5].[20180503]))', SOLVE_ORDER = 1.0
select {[Measures].[交易净额], [Measures].[交易笔数]} ON COLUMNS,
  Hierarchize(Distinct({[商户编码].[102664980159], [商户编码].[102664980159].Children, [商户编码].[102382003372], [商户编码].[102382003372].Children})) ON ROWS
from [商户日结]
where [日期].[时间段合计]