namedsetcalcmember.mdx

< SQL Server2005程序设计>

SELECT	Time.[Year -  Quarter -  Month -  OrderDate].Year.MEMBERS 
		 ON COLUMNS,
		[Test Markets] ON ROWS
FROM	Sales
WHERE	Measures.[Adjusted Sales]