MDX 语句优化 达人coming

[Mirror然]

不知道是数据切割问题还是在日期划分上有问题

 with member KeyMembers as [Dim Product].[Product Dev Cd III].currentmember.Properties('key')  
 select {([Measures].[Sales Amount]),([Measures].[Quantity]),([Measures].[ProductCount]),(KeyMembers)} 
 on 0 , Order( nonEmpty([Dim Product].[Product Dev Cd III].Members) ,Measures.[Sales Amount] , DESC )  
 on 1    from  ( select ({ ([Dim Product].[Product Dev Cd III].&[1304]) }) on 0  
  from  ( select ({ ([Dim Shop].[Shop Uni Cd].&[99991001010103]),([Dim Shop].[Shop Uni Cd].&[999910010102]),
  ([Dim Shop].[Shop Uni Cd].&[99991001010201]),([Dim Shop].[Shop Uni Cd].&[99991001010301]),
  ([Dim Shop].[Shop Uni Cd].&[99991001010401]),([Dim Shop].[Shop Uni Cd].&[999910010201]),
  ([Dim Shop].[Shop Uni Cd].&[999910010202]),([Dim Shop].[Shop Uni Cd].&[999910010302]),
  ([Dim Shop].[Shop Uni Cd].&[999910010303]),([Dim Shop].[Shop Uni Cd].&[999910010304]),
  ([Dim Shop].[Shop Uni Cd].&[999910010305]),([Dim Shop].[Shop Uni Cd].&[999910010306]),
  ([Dim Shop].[Shop Uni Cd].&[999910010307]),([Dim Shop].[Shop Uni Cd].&[999910010308]),
  ([Dim Shop].[Shop Uni Cd].&[999910010401]),([Dim Shop].[Shop Uni Cd].&[999910010402]),
  ([Dim Shop].[Shop Uni Cd].&[9999100105]),([Dim Shop].[Shop Uni Cd].&[9999100106]),
  ([Dim Shop].[Shop Uni Cd].&[9999100108]),([Dim Shop].[Shop Uni Cd].&[9999100109]),
  ([Dim Shop].[Shop Uni Cd].&[9999100301]),([Dim Shop].[Shop Uni Cd].&[9999100401]),
  ([Dim Shop].[Shop Uni Cd].&[9999100501]),([Dim Shop].[Shop Uni Cd].&[9999100701]),
  ([Dim Shop].[Shop Uni Cd].&[9999300201]),([Dim Shop].[Shop Uni Cd].&[9999300301]),
  ([Dim Shop].[Shop Uni Cd].&[9999300601]) }) on 0   
  from  ( select ({ ([Dim Product].[Product Area Cd].&[001])  }) on 0 from  [SMBIDBCUBE]   )    )    )
    where {(( [Dim Date Summary].[Date Key].[20150701]) : ([Dim Date Summary].[Date Key].[20150816])) }  

上述语句是可以执行的，但是把日期改成20150731 查询出来的就是空数据
下面精简了查询条件，就可以查询出来数据。。 很纳闷了

 with member KeyMembers as [Dim Product].[Product Dev Cd III].currentmember.Properties('key')  
 select {([Measures].[Sales Amount]),([Measures].[Quantity]),([Measures].[ProductCount]),(KeyMembers)} 
 on 0 , Order( nonEmpty([Dim Product].[Product Dev Cd III].Members) ,Measures.[Sales Amount] , DESC )  
 on 1    from  ( select ({ ([Dim Product].[Product Dev Cd III].&[1304]) }) on 0  
  from  ( select ({ ([Dim Shop].[Shop Uni Cd].&[99991001010103]) }) on 0   
  from    ( select ({ ([Dim Product].[Product Area Cd].&[001])  }) on 0 from  [SMBIDBCUBE] )) )
    where {(( [Dim Date Summary].[Date Key].[20150731]) : ([Dim Date Summary].[Date Key].[20150816])) }  

[Mirror然]

nobady ?