drilldownmember.mdx

< SQL Server2005程序设计>

SELECT	NONEMPTY(Shippers.[Shipper Name].MEMBERS) ON COLUMNS,
		NONEMPTYCROSSJOIN(Time.Year.MEMBERS,
						  DRILLDOWNMEMBER(Geography.[Country - State-Province - City - Postal Code].Country.MEMBERS, 
										  {CANADA, USA})) ON ROWS
FROM	Sales
WHERE	(Measures.[Total Sales],
		 Products.[Category Name].Condiments)