Hi,

Somebody could tell me how can I create a file .CUB?

Thanks

There are a number of different ways of doing it....

1) You can easily use Microsoft Excel 2000, building a
Pivot Table. Whe you are in the pivot table you can use an
appropriate command to create local cube.

2) You could also create the local cube manually using
Proclarity.

3) You could automate the process using something like
http://www.localcubetask.com/

4) You could write your own code to create the cubes using
the 'old' CREATE CUBE
syntax, as detailed in BOL. Not recommended though since
it's very complicated.

5) You could write your own code to create the cubes using
the 'new' CREATE GLOBAL
CUBE, as detailed in this whitepaper:
http://www.microsoft.com/sql/evaluation/BI/AnSvcDDL.asp

HTH

Cheers,
Sanka

Courtesy : Chris Webb:Edoardo Antonucc
July 2002