Are DDL MDX commands in AS2000 to e.g. create measures, cubes etc?

MDX DDL capabilites are limited, as discussed in this post:

http://groups.google.com/group/micro...olap/msg/ee924
fd62de39d37

From: SQL Server Development Team [MSFT]
Date: Thurs, Jan 30 2003 1:53 pm

Unfortunately, MDX can only be used to create local cubes and mining
models - to create server cubes and objects, you must use DSO. If you
want
to create local cubes, you'll want to use the new "2nd edition" DDL
described in the whitepaper, "Using Data Definition Language with SQL
Server
2000 Analysis Services", located at
http://www.microsoft.com/sql/evaluation/BI/AnSvcDDL.asp. The CREATE
GLOBAL
CUBE statement described in the whitepaper is much easier to use than
the
full-blown CREATE CUBE statement described in Books Online.

Hope this helps,
Dennis Kennedy
...

As mentioned above, the DSO (Decision Support Object) interface can be
used to create server cubes:

http://msdn.microsoft.com/library/de.../en-us/olapdmp
r/prrefintro_2mcl.asp

Microsoft® SQL Server™ 2000 Analysis Services offers substantial
opportunity for you to create and integrate custom applications. The
server object model, Decision Support Objects (DSO), provides interfaces
and objects that can be used with any COM automation programming
language such as Microsoft® Visual Basic® (version 5.0 and later).
Additionally, Microsoft Visual C++® programmers can use DSO. DSO objects
support both early and late binding.

The Programmer's Reference provides detailed information about DSO for
use in developing custom applications that interact with the Analysis
server.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***