So far, I have been using business intelligence development studio's wizards
to create cubes and dimensions. How can I create cubes using script language
like

CREATE CUBE MY CUBE

CREATE DIMENSION MY DIMENSION...

Is it possible??

TIA...

see the XML/A commands
and other DDL language
(see the help and serach on the web for more info)

using the management studio...
but the best way to start is to right click on a cube, then select the right
option and the management studio will generates the complete syntax to
create the cube.


"sqlster" <nospam (AT) nospam (DOT) com> wrote