What is the best way to programatically create cubes on the server?

Should I use the DDL subset of MDX with ADOMD/ADOMD.NET? Or must I use DSO
to do it?

Resources are quite fuzzy on this. According to George Spofford's "MDX
Solutions", the CREATE CUBE statement is used to build local cube files (pg.
215). There's also some brief comments on creating virtual cubes on pg.
214, and the wonderfully enlightening sentence on pg. 131 "The virtual cube
version of the CREATE CUBE statement will be executed but will not have any
effect."

I don't want to create a local cube, and I don't want to create a virtual
cube. Just a regular, plain ole cube up on the Analysis Server.

Now supposedly the DDL was expanded in AS SP1, and there's a LOCALCUBE.EXE
file one can download that is supposed to demonstrate the new CREATE GLOBAL
CUBE statement. The CreateCube.txt file says ...

-----
For a more detailed discussion of the enhanced DDL, the reader is referred
to the "Using Data Definition Language with SQL Server 2000 Analysis
Services Client Applications" written by Dennis Kennedy
-----

This document, unfortunately has been removed according to Stephen Dybing's
response to a previous post of mine, although there is still a KB article
that references the document. What I gathered from Stephen's response is
he's going to tell the KB team so they can remove the out-of-date KB
article. Apparently the greatly expanded and enhanced DDL that was heralded
with the arrival of AS SP1 is now out of date, as MS has seen fit to remove
any documentation references to it.

- Kevin

You'll need to use DSO to create cubes on the server. For more information
on using DSO, you can search for the following article on MSDN...

"Developing Effective Decision Support (DSO) Solutions with Microsoft SQL
Server 2000 Analysis Services" by Dennis Kennedy.



--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.



"Kevin Dietz" <kevinbizbox1 (AT) earthlink (DOT) net> wrote