offlinefile.mdx

< SQL Server2005程序设计>

CREATE GLOBAL CUBE [Sales] STORAGE 'C:\Sales.cub' FROM [Sales]
(
	MEASURE [Sales].[Total Sales],

	DIMENSION [Sales].[Employees].[Employee Name]
	(
		LEVEL [(All)],
		LEVEL [Employee Name],
		MEMBER [Employees].[Employee Name].&[Buchanan, Steven],
		MEMBER [Employees].[Employee Name].&[Callahan, Laura],
		MEMBER [Employees].[Employee Name].&[Davolio, Nancy],
		MEMBER [Employees].[Employee Name].&[Dodsworth, Anne],
		MEMBER [Employees].[Employee Name].&[Fuller, Andrew],
		MEMBER [Employees].[Employee Name].&[King, Robert],
		MEMBER [Employees].[Employee Name].&[Leverling, Janet],
		MEMBER [Employees].[Employee Name].&[Peacock, Margaret],
		MEMBER [Employees].[Employee Name].&[Suyama, Michael]
	),
	DIMENSION [Sales].[Geography].[Country]
	(
		LEVEL [(All)],
		LEVEL [Country],
		MEMBER [Geography].[Country].&[Argentina],
		MEMBER [Geography].[Country].&[Austria],
		MEMBER [Geography].[Country].&[Belgium],
		MEMBER [Geography].[Country].&[Brazil],
		MEMBER [Geography].[Country].&[Canada],
		MEMBER [Geography].[Country].&[Denmark],
		MEMBER [Geography].[Country].&[Finland],
		MEMBER [Geography].[Country].&[France],
		MEMBER [Geography].[Country].&[Germany],
		MEMBER [Geography].[Country].&[Italy],
		MEMBER [Geography].[Country].&[Mexico],
		MEMBER [Geography].[Country].&[Norway],
		MEMBER [Geography].[Country].&[Poland],
		MEMBER [Geography].[Country].&[Portugal],
		MEMBER [Geography].[Country].&[Spain],
		MEMBER [Geography].[Country].&[Sweden],
		MEMBER [Geography].[Country].&[Switzerland],
		MEMBER [Geography].[Country].&[UK],
		MEMBER [Geography].[Country].&[USA],
		MEMBER [Geography].[Country].&[Venezuela]
	),
	DIMENSION [Sales].[OrgChart].[Reports To]


)