SQL Server 2000 creates a cub file corresponding to a multi-dimensional dataset

SQL Server 2000 creates a cub file for a multi-dimensional dataset

 

Choose Mircosoft SQL Server> Analysis Services> MDX sample application.ProgramAnd then you can write mdx

Assume that the (db) multi-dimensional database cetscoredw is created using as and the (cube) Multi-Dimensional Data Set cetscore is created. You can use the following statement to store the multi-dimensional data set as a. Cub file,
You can use the. Cub file for offline analysis.

Create Global cube [cetscore] // Multidimensional Dataset name cetscore
Storage 'C:/cetscore. cub' // path for storing the cub File
From [cetscore] // Multidimensional Dataset cetscore
(
Measure [cetscore]. [number of trainees],
Measure [cetscore]. [number of successful users],
Measure [cetscore]. [pass the total score],
Measure [cetscore]. [total score], // Measure

dimension [cetscore]. [address], // address dimension of the multi-dimensional cetscore dataset
dimension [cetscore]. [time],
dimension [cetscore]. [NJ],
dimension [cetscore]. [XL],
dimension [cetscore]. [level]
)