Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 815

Shown below is the statement sent to Analysis Services instance to create an off-
line cube with your selections of measures and hierarchy levels. This statement
can also be executed from SQL Server Management Studio.
CREATE GLOBAL CUBE [Direct Sales] STORAGE 'D:\Direct
Sales.cub' FROM [Direct Sales]
(
MEASURE [Direct Sales].[Internet Sales Amount],
DIMENSION [Direct Sales].[Customer].[Customer
Geography]
(
LEVEL [(All)],
LEVEL [State-Province],
LEVEL [City]
),
DIMENSION [Direct Sales].[Date].[Fiscal]
(
LEVEL [(All)],
LEVEL [Fiscal Year]
),
DIMENSION [Direct Sales].[Product].[Product
Categories]
(
LEVEL [(All)],
LEVEL [Category]
)
)
In the Offline OLAP Settings page (shown in Figure 15-38 ) select Offline
OLAP and click OK. The operations including drill up and drill down, ap-
propriate member selections, and so forth, all of which you did online,
can also be performed offline. Once the offline cube (usually a subset
of the server cube) is created, it can then be distributed to business
decision-makers who do not need real-time access to the server cube.