不知道是数据切割问题还是在日期划分上有问题
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])) }
