STEP 1.
===============================================================================
WITH MEMBER [Team].[teamName].Total AS
Aggregate ( { [Team].[teamName].&[AP Doc_Capture],[Team].[teamName].&[AP Payments]})
WITH MEMBER…………AS…………
是一个计算,计算聚合2个组的数据
([Team].[teamName].&[AP Doc_Capture]和[Team].[teamName].&[AP Payments]})
===============================================================================
STEP 2.
===============================================================================
SET [TeamNames] AS { [Team].[teamName].&[AP Doc_Capture],[Team].[teamName].&[AP Payments],[Team].[teamName].&[AP SAHS]}
SET…………………AS……………
是一个集合,把2个组放在一个集合里,作为查询的条件(取这2个组的数据)
([Team].[teamName].&[AP Doc_Capture]和[Team].[teamName].&[AP Payments]})
===============================================================================
STEP 3.
===============================================================================
SELECT {LastPeriods(7,[Task Date].[Date].&[2011-08-14T00:00:00])} ON COLUMNS,
行显示从2011-08-14开始前7天的日期
===============================================================================
STEP 4.
===============================================================================
NONEMPTY({([Measures].[Keyvol Units],[team].[teamName].Total),--TOTAL
([Measures].[Keyvol Units],[TeamNames]),---------SET结合
([Measures].[Keyvol In],[team].[teamName].Total),
([Measures].[Keyvol In],[TeamNames]),
([Measures].[LASTKV],[team].[teamName].Total),