hxp42的专栏

http://msdn.microsoft.com/zh-cn/library/ms144866(v=sql.105).aspx

sum( ( ParallelPeriod([Date].[Calendar].[Month],35,[Date].[Calendar].currentmember) : [Date].[Calendar].currentmember ) , [Measures].[XXX度量] )sum((ParallelPeriod([Date].[Calendar].[Year],1,[Date].[C

SELECT {[Measures].[XX度量]} ON COLUMNS,  {nonempty(EXCEPT([A维度].[A].[A].ALLMEMBERS,{[A维度].[A].&[-1],[A维度].[A].[All].UNKNOWNMEMBER}))  *except([B维度].[B].[B].ALLMEMBERS,{[B维度].[B].&[-1],[B维度].[B].[Al